Referencing Sheet names/numbers
Well blow me. I thought the codenames were set in stone. I thought only
the sheet name could be changed.
Thanks Dave that will certainly be useful to me.
Ronnie
Dave Peterson wrote in
:
Glad you got it working.
I'm not sure if this affects your current project, but you can change
the codename "(Name)" (in the properties window inside the VBE) to
something more meaningful.
Instead of using Sheet1, Sheet2, Sheet3, ...
You could use:
Prices, Accounts, Discounts
And your code would be more self-documenting.
|