View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
VicWestVan VicWestVan is offline
external usenet poster
 
Posts: 10
Default How to Variable Reference Row Ranges?

I'm trying to use variables to reference row ranges but don't know the syntax
or correct command. Instead of using a command like:

Range("5:9")

I'm trying to reference a number of row groups i.e. 5:9, 10:14, 15:19 and
would like to be able to use a command like:

Range("var1,var2") but this doesn't seem to work.

Any ideas....