Dynamic range selection

[Fernando Ronci]

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+DeltaC)).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: (e-mail address removed)

 

[Frank Kabel]

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