Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
My workbook has approximately 100 worksheets, and about 30
of these have charts. I would like to loop through the sheets, and make sure that cell A1 is selected. Sub SelectA1 For i = 1 to Sheets.count Sheets(i).visible = True Sheets(i).select cells(1,1).select Next i End Sub The problem is, sometimes a chart is selected, and so I get an error if I try to select cell A1. Can anyone improve my loop to handle the cases when a chart is selected? Thanks in advance Daniel Bonallack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Loop all Sheets not working. | New Users to Excel | |||
Loop through varible list of sheets | Excel Discussion (Misc queries) | |||
Use a loop to create multiple Charts - Suggestions ? | Charts and Charting in Excel | |||
Charts from Spread sheets | Excel Discussion (Misc queries) | |||
ActiveChart.Deselect won't Deselect | Charts and Charting in Excel |