Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In trying to code a procdure I want to have range A5 as the starting location
for each sheet (to be used in code later as the active cell for each sheet when made active.) I was having trouble so I recorded the key stroke as a macro and it works. I copy the code to a procedure, run it from a command button and I get the following error msg: Select method of Range Class failed. Here is the simple code: Sheets("Sheet1").Select Range("A5").Select Sheets("Sheet2").Select Range("A5").Select Help is appreciated. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VBA macro runs fine, but freezes if I try to do ANYTHING else whileit runs | Setting up and Configuration of Excel | |||
One macro runs then it auto runs another macro | Excel Discussion (Misc queries) | |||
how to create a macro that runs other macro in the same workbook | Excel Programming | |||
Macro runs in source , but not when in Personal Macro Workbook | Excel Programming |