VBA_Newbie
Active Member
- Joined
- Jan 7, 2005
- Messages
- 258
Hi folks,
Can anyone tell me the syntax to set a Range equal to the current selection.
For instance, suppose I have:
Dim NewRange as Range
Set NewRange = ? (current selection)
I've only ever used the activecell.currentregion, but in this particular circumstance I only want to work on a specific area of cells that contain data values, not the entire region of cells that are not seperated by a blank line or column. Many Thanks.
Can anyone tell me the syntax to set a Range equal to the current selection.
For instance, suppose I have:
Dim NewRange as Range
Set NewRange = ? (current selection)
I've only ever used the activecell.currentregion, but in this particular circumstance I only want to work on a specific area of cells that contain data values, not the entire region of cells that are not seperated by a blank line or column. Many Thanks.