Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to first empty worksheet in a certain group of sheets
Hello All,
I have a group of 10 worksheets hidden in a Workbook. Im looking for a Macro to find the first empty sheet in that 10 page hidden group. Each sheet in the group is named T with a number next to the T (i.e. T1, T2,T3, T4.etc). The criteria for the page being empty is based on cell A1 being empty. Any thoughts would be greatly appreciated. Thank you Roger |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to first empty worksheet in a certain group of sheets
Hello Roger
Sub FindFirstEmpty() Dim sh As Worksheet Dim i As Integer For i = 1 To 10 If Worksheets("T" & i).Range("A1") = "" Then MsgBox "First empty cell found in sheet T" & i Exit For End If Next i End Sub "Roger" a crit dans le message de news: ... Hello All, I have a group of 10 worksheets hidden in a Workbook. I'm looking for a Macro to find the first empty sheet in that 10 page hidden group. Each sheet in the group is named "T" with a number next to the T (i.e. T1, T2,T3, T4...etc). The criteria for the page being empty is based on cell A1 being empty. Any thoughts would be greatly appreciated. Thank you - Roger |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to first empty worksheet in a certain group of sheets
Thank you Papou - works great!
Roger "papou" wrote: Hello Roger Sub FindFirstEmpty() Dim sh As Worksheet Dim i As Integer For i = 1 To 10 If Worksheets("T" & i).Range("A1") = "" Then MsgBox "First empty cell found in sheet T" & i Exit For End If Next i End Sub "Roger" a écrit dans le message de news: ... Hello All, I have a group of 10 worksheets hidden in a Workbook. I'm looking for a Macro to find the first empty sheet in that 10 page hidden group. Each sheet in the group is named "T" with a number next to the T (i.e. T1, T2,T3, T4...etc). The criteria for the page being empty is based on cell A1 being empty. Any thoughts would be greatly appreciated. Thank you - Roger |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to first empty worksheet in a certain group of sheets
One last question. Is there a way to select and go to that sheet vs. a message box? Thanks - Roger "Roger" wrote: Hello All, I have a group of 10 worksheets hidden in a Workbook. Im looking for a Macro to find the first empty sheet in that 10 page hidden group. Each sheet in the group is named T with a number next to the T (i.e. T1, T2,T3, T4.etc). The criteria for the page being empty is based on cell A1 being empty. Any thoughts would be greatly appreciated. Thank you Roger |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Go to first empty worksheet in a certain group of sheets
Hi Roger
Sub FindFirstEmpty() Dim sh As Worksheet Dim i As Integer For i = 1 To 10 If Worksheets("T" & i).Range("A1") = "" Then Worksheets("T" & i).Activate Exit For End If HTH Cordially Pascal "Roger" a crit dans le message de news: ... One last question. Is there a way to select and go to that sheet vs. a message box? Thanks - Roger "Roger" wrote: Hello All, I have a group of 10 worksheets hidden in a Workbook. I'm looking for a Macro to find the first empty sheet in that 10 page hidden group. Each sheet in the group is named "T" with a number next to the T (i.e. T1, T2,T3, T4...etc). The criteria for the page being empty is based on cell A1 being empty. Any thoughts would be greatly appreciated. Thank you - Roger |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
moving page breaks in a group of sheets | Excel Discussion (Misc queries) | |||
group sheets with macro in excel | Excel Discussion (Misc queries) | |||
group excel sheets within workbook | Excel Discussion (Misc queries) | |||
Group and ungroup protected sheets | Excel Discussion (Misc queries) | |||
Group Sheets | Excel Discussion (Misc queries) |