| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Offset with variable?
I get an error on this simple line of code...
st1 = st1.Offset(1, 0) st1 is a range... is there anyother way to make st1 step one cell down? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Offset with variable?
st1 is an object and therefore must be set...
Set st1 = st1.Offset(1,0) HTH Die_Another_Day John wrote: I get an error on this simple line of code... st1 = st1.Offset(1, 0) st1 is a range... is there anyother way to make st1 step one cell down? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookup Variable Offset | Excel Discussion (Misc queries) | |||
| Variable worksheet name in offset | Excel Worksheet Functions | |||
| Offset with variable? | Excel Programming | |||
| Offset with variable | Excel Programming | |||
| How to Offset string variable? | Excel Programming | |||
Hybrid Mode
