Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CODE 2 SELECT SHEETS LISTED IN A RANGE
What code would select sheets that are named in the range: Sheet1!A1:A10
ignoring blanks cells, if any? Thanx in advance. -- Best Regards, Faraz |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CODE 2 SELECT SHEETS LISTED IN A RANGE
give this a try
Sub select_sheets() Dim ws As Worksheet Dim cell As Range Set ws = Worksheets("Sheet1") For Each cell In ws.Range("A1:A10") On Error Resume Next If cell.Value "" Then Worksheets(cell.Value).Select False End If On Error GoTo 0 Next End Sub -- Gary Keramidas Excel 2003 "Faraz A. Qureshi" wrote in message ... What code would select sheets that are named in the range: Sheet1!A1:A10 ignoring blanks cells, if any? Thanx in advance. -- Best Regards, Faraz |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CODE 2 SELECT SHEETS LISTED IN A RANGE
Thanx Gary,
However, the code keeps the already active sheet to remain in the selected one. -- Best Regards, Faraz "Gary Keramidas" wrote: give this a try Sub select_sheets() Dim ws As Worksheet Dim cell As Range Set ws = Worksheets("Sheet1") For Each cell In ws.Range("A1:A10") On Error Resume Next If cell.Value "" Then Worksheets(cell.Value).Select False End If On Error GoTo 0 Next End Sub -- Gary Keramidas Excel 2003 "Faraz A. Qureshi" wrote in message ... What code would select sheets that are named in the range: Sheet1!A1:A10 ignoring blanks cells, if any? Thanx in advance. -- Best Regards, Faraz |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
CODE 2 SELECT SHEETS LISTED IN A RANGE
kind of late here, so i'll just make this simple addition to the code
Sub select_sheets() Dim wsname As String Dim ws As Worksheet Dim cell As Range Dim cntr As Long cntr = 0 wsname = ActiveSheet.Name Set ws = Worksheets("Sheet1") For Each cell In ws.Range("A1:A10") On Error Resume Next If cell.Value "" Then If cntr = 0 Then Worksheets(cell.Value).Select cntr = cntr + 1 ElseIf cell.Value "" Then Worksheets(cell.Value).Select False End If End If On Error GoTo 0 Next End Sub -- Gary Keramidas Excel 2003 "Faraz A. Qureshi" wrote in message ... Thanx Gary, However, the code keeps the already active sheet to remain in the selected one. -- Best Regards, Faraz "Gary Keramidas" wrote: give this a try Sub select_sheets() Dim ws As Worksheet Dim cell As Range Set ws = Worksheets("Sheet1") For Each cell In ws.Range("A1:A10") On Error Resume Next If cell.Value "" Then Worksheets(cell.Value).Select False End If On Error GoTo 0 Next End Sub -- Gary Keramidas Excel 2003 "Faraz A. Qureshi" wrote in message ... What code would select sheets that are named in the range: Sheet1!A1:A10 ignoring blanks cells, if any? Thanx in advance. -- Best Regards, Faraz |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
CODE 2 SELECT SHEETS LISTED IN A RANGE
On Error Resume Next
With WorkSheets("Sheet1") .Activate .Range("A1:A10").SpecialCells(xlCellTypeConstants, 23).Select End With "Faraz A. Qureshi" a écrit dans le message de groupe de discussion : ... What code would select sheets that are named in the range: Sheet1!A1:A10 ignoring blanks cells, if any? Thanx in advance. -- Best Regards, Faraz |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CODE 2 SELECT SHEETS LISTED IN A RANGE | Excel Discussion (Misc queries) | |||
How to select a listed item? | Excel Worksheet Functions | |||
How to select a listed item? | Excel Discussion (Misc queries) | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Worksheet Functions | |||
How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook? | Excel Programming |