| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting a range in code
Here is a line of code I'm having problems with:
Sub SingleDoor(SCell as Integer) Range("A" & SCell + 5 ":C" & SCell + 10) I know it is my syntax that is wrong. Can anyone help? I would like to select the range of cell from A5:C10 if SCell is passed as 1. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting range in list of range names depending on a cell informa | Excel Discussion (Misc queries) | |||
| VBA Code for selecting row | Excel Discussion (Misc queries) | |||
| VBA Code for selecting days | Excel Programming | |||
| Selecting cells for code | Excel Programming | |||
| Selecting a PivotItem in code | Excel Programming | |||
Threaded Mode
