View Single Post
  #11   Report Post  
Posted to microsoft.public.excel.programming
Otto Moehrbach Otto Moehrbach is offline
external usenet poster
 
Posts: 1,090
Default Range as Variable

Try:
Set X = Range("A1:B4")
"Alan Beban" wrote in message
...
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

Dim X As Range
X = Range("A1:B4")