View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tskogstrom tskogstrom is offline
external usenet poster
 
Posts: 92
Default Store variables in code just as you can w. constants? Available to read/edit?

Hi,
Constants can be set, but is there a way to change them dynamically
when needed, during the work in the workbook? To be used as variables
instead?

I want to store a number of ranges (actually, number of areas) and
have earlier tried to use "cell.value = [range].address" stored in
worksheet cells, but have stranded in that approach and search after
another way.

Best would be if they are accessible from all modules & subs, if
possible.

Kind regards
Tskogstrom