Dynamic web site solutions

  User 'guest' at  home/ms-excel/

  • Home
  • PHP
  • VBA
  • MS Excel
  • MS Access
  • MySQL
  • HTML
  • CSS
  • Site Map
  • Contact
  • About




Email:


Password:


  Register

Sign in with OpenID


Browse MS Excel Content



Excel VBA bug creates incorrect conditional format cell references

By: Mark Kiehl


Sub CreateConditionalFmt()
'Mark Kiehl, 24Feb2009, www.SavyCode-Solutions.com

'Excel VBA bug creates incorrect conditional format cell references.
'
'Excel has ..


Click to view this record..

Excel path/filenames

By: Mark Kiehl


Sub ShowFilePaths()
MsgBox Application.ActiveWorkbook.ActiveSheet.Name, vbInformation, "Active sheet"
MsgBox Application.ThisWorkbook.Path, vbInformation, "ThisWorkbook.Path"
MsgBox Application.DefaultFilePath, ..


Click to view this record..

1   ... 2   Next

Copyright © 2009   Mark Kiehl,   All Rights Reserved               Site created by http://www.bizwebsites.us/      Script time elapsed: 0.012145996094