View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Fleming[_2_] Ian Fleming[_2_] is offline
external usenet poster
 
Posts: 1
Default Pass a variable into a range?

I'm trying to produce a graph in Excel using macros, my problem is that
the amount of data is not always the same (there could be 4 rows or 24
lines), is there any way to pass a variable into a range say for
("A1:M6") = ("A1:M"variable")? I have tried using named ranges but that
just gives me the same issue. Thanks for any help.

Ian B. Fleming
MS Excel and VBA

*** Sent via Developersdex http://www.developersdex.com ***