Thread: Range as Variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban[_2_] Alan Beban[_2_] is offline
external usenet poster
  
Posts: 783
Default Range as Variable
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")
Reply With QuoteReply With Quote