How to declare a variable for several subs
I have a workbook I've been developing under XL2K in which I reference the
number of rows and columns in a named range in several VBA subroutines
within a single module:
NumRows = Range("Name_Copy").Rows.Count
NumCols = Range("Name_Copy").Columns.Count
Is there a way to make those available to all subs within my module without
having to put them in each individual subroutine?
If so, I need exact syntax please.
--
David
|