Computer programming code solutions

  User 'guest' at  home/ms-excel/

  • Home
  • PHP
  • ASP.NET 2.0
  • VBA
  • MS Excel
  • MS Access
  • MySQL
  • MS SQL Server
  • HTML
  • CSS
  • Site Map
  • Contact
  • About



  Click here for more information..

Email:


Password:


  Register
Reset password

Sign in with OpenID


RSS feed  Click to subscribe to the RSS feed.

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   ... 4   Next

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