View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
cappy2112 cappy2112 is offline
external usenet poster
 
Posts: 13
Default First Time VBA user- really easy question :-)

On Jun 18, 12:02 pm, "Chip Pearson" wrote:
You can't directly read the version number from a worksheet cell. You need a
function in a module (create from "Insert" menu in VBA) that will read the
constant and return its value to the worksheet cell. E.g.,

Public Function GetVersion()
GetVersion = ProgramVersionNumber
End Function


Thanks-
Using a function makes better sense than accessing a variable (or
const) directly.