| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Dynamic Range in VBA
Hi all,
I'm sure this is any easy one, How do you make a got to range/reference dynamic? You see I want to goto to use the range stated in a cell Ie Application.Goto Range("c3") But this code only goes to the cell not the range in the cell?? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamic Range in VBA
Dim S as String
S = Range("C3").Value Application.Goto Range(S) -- Gary's Student " wrote: Hi all, I'm sure this is any easy one, How do you make a got to range/reference dynamic? You see I want to goto to use the range stated in a cell Ie Application.Goto Range("c3") But this code only goes to the cell not the range in the cell?? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamic Range in VBA
Perfect,
Thanks a lot for that. I really needed it Thanks again |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Dynamic Range in VBA
You are very welcome !
-- Gary's Student " wrote: Perfect, Thanks a lot for that. I really needed it Thanks again |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| getting the absolute range address from a dynamic named range | Excel Programming | |||
| Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
| copying dynamic range based on cell outside of range | Excel Programming | |||
| select dynamic range with dynamic start point | Excel Programming | |||
| Excel 2000 VBA - Set Print Range in dynamic range | Excel Programming | |||
Linear Mode
