Thread: Range ("1:7") With Variables?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
barnabel barnabel is offline
external usenet poster
  
Posts: 119
Default Range ("1:7") With Variables?
One simple way (I'm sure other people will present other ways) is:
Range(var1 & ":" & var2)

"J@Y" wrote:

How would I express Range ("1:7") by replacing the 1 and the 7 with integer
variables?
Reply With QuoteReply With Quote