Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Setting Range Variable
I would like to set a variable equal to whatever the currently selected range
is on my spreadsheet. I have started my procedure as follows (assuming that a given range of cells has already been selected on my spreadsheet): Dim rng as Range Set rng = Active range of cells currently selected What is the code I need for describing the active range? Thanks. -- Steve C |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting a Variable range in VBA | Excel Programming | |||
Setting a range within a loop variable for copy/paste | Excel Programming | |||
setting a range variable equal to the value of a string variable | Excel Programming | |||
Setting range value to a variable | Excel Programming | |||
Setting up a variable print range | Excel Programming |