Range as Variable
or..
you can highlight a range....
dim x as range
set x = selection
msgbox x.address
regards
FSt1
"FSt1" wrote:
hi
current range?????
dim x as range
set x = range("A1:L100")'set to current range
regards
FSt1
"lwm" wrote:
I want to take the current range and assign it to a variable touse in
additional functions.
How do I assign the current range to a variable like X?
Thanks
|