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