Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Check for Blanks formula, please
Excel 2003 SR2
I am combining several worksheets into one. I'm doing this 5 times for 5 alphabetic ranges. Some times I need to combine 4 worksheets, or 5 or 6, depending if worksheet 5 or 6 have data (if 5 doesn't, 6 will be blank, also). So - if B1 of Worksheet 5 is blank, I want to jump to the next routine. But if B1 of Worksheet 5 has data, I want it to process the next instruction, then go to Worksheet 6 and check B1. Question - how do I do this? TIA CaroleO |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Check for Blanks formula, please
Sub Carole()
For i = 1 To 5 If IsEmpty(Sheets(i).Range("B1")) Then Else MsgBox ("procesing sheet #" & i) End If Next End Sub -- Gary''s Student - gsnu200718 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Check for Blanks formula, please
Thank you! I figured out the i = 1 To 5 means the 1st through 5th worksheets
- regardless of what they are named in the tab, so was able to adjust the formula. The MsgBox was good to test the code, but I eliminated it after it worked since I'm turning this over to someone else to run. Thanks again for giving me the clues to make it work - yea!! CaroleO "Gary''s Student" wrote: Sub Carole() For i = 1 To 5 If IsEmpty(Sheets(i).Range("B1")) Then Else MsgBox ("procesing sheet #" & i) End If Next End Sub -- Gary''s Student - gsnu200718 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need Check for Blanks formula, please
You are welcome. Have a pleasant weekend.
-- Gary''s Student - gsnu200718 "Carole O" wrote: Thank you! I figured out the i = 1 To 5 means the 1st through 5th worksheets - regardless of what they are named in the tab, so was able to adjust the formula. The MsgBox was good to test the code, but I eliminated it after it worked since I'm turning this over to someone else to run. Thanks again for giving me the clues to make it work - yea!! CaroleO "Gary''s Student" wrote: Sub Carole() For i = 1 To 5 If IsEmpty(Sheets(i).Range("B1")) Then Else MsgBox ("procesing sheet #" & i) End If Next End Sub -- Gary''s Student - gsnu200718 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct copying blanks or how to insert zero into blanks | Excel Worksheet Functions | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
replace blanks using formula | Excel Worksheet Functions | |||
USING IGNORE BLANKS IN FORMULA | Excel Discussion (Misc queries) | |||
Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) |