ExcelBanter - Dynamic range selection

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Dynamic range selection (https://www.excelbanter.com/excel-programming/306024-dynamic-range-selection.html)

Fernando Ronci

Dynamic range selection

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:

Frank Kabel

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:

All times are GMT +1. The time now is 02:21 PM.