| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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: |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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: |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic Range Selection Using VBA | Excel Discussion (Misc queries) | |||
| Need Help on Dynamic Range Selection | Excel Discussion (Misc queries) | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| Excel VBA - Range(Selection, Selection.End(xlDown)).Name issue. | Excel Programming | |||
| Dynamic Range Selection | Excel Programming | |||
Linear Mode
