Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Selecting Precedents On Other Sheet Via Macro
The following macro selects precedents only if on the current sheet.
Sub Macro1() ActiveCell.Precedents.Select End Sub If the cell contains reference to some other sheet in the same book the error 1004 stating "No Cells Found" pops up. Any suggestion? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Selecting sheet with VB | Excel Discussion (Misc queries) | |||
Range Address of Precedents and Dependents from other sheet. | Excel Discussion (Misc queries) | |||
Selecting data from database sheet | Excel Discussion (Misc queries) | |||
Selecting Last Sheet | Excel Worksheet Functions | |||
Selecting a sheet from a drop down box | Excel Discussion (Misc queries) |