View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Dynamic range selection

Hi
try
Range(Cells(Row1,Col1),Cells(Row1+DeltaR,Col1+Delt aC)).Select

--
Regards
Frank Kabel
Frankfurt, Germany


Fernando Ronci wrote:
Hi,

I'm stuck with a macro. I want to select a range whose coordinates

are
stored in variables. I tried
"Range(Cells(Row1,Col1):Cells(Row1+DeltaR,Col1+Del taC)).Select" but

it
didn't work. Online help wasn't very helpful in this case.
What's the right way to do it ?

Thank you,
Fernando Ronci
E-mail: