Home |
Search |
Today's Posts |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
easy use 12 month planner, complex elements, basic user, help | Excel Worksheet Functions | |||
Freqencies over Time, in Columns -- Easy Question | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
*Easy* question this time! | Excel Programming |