| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to assign a variable in a range select
Another way...
activecell.resize(1,5).select Paul wrote: I tried to assign a variable for a cell range and it returns with an error. Thanks. ActiveCell.Offset(0, 1).Select Range("ActiveCell.Offset(0, 0):ActiveCell.Offset(0, 4)").Select........this code does not work -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Select a variable range | Excel Worksheet Functions | |||
| Use a Variable to select a range | Excel Discussion (Misc queries) | |||
| How can I assign a range starting cell based on a variable locati. | Excel Discussion (Misc queries) | |||
| How can I assign a range starting cell based on a variable locati. | Excel Worksheet Functions | |||
| Range.Select with variable cells ? | Excel Programming | |||
![Dave Peterson[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
