How do you know if a worksheet is empty (blank)? I am using the following code to populate a worksheet.
If sheet(5) is not blank I want to delete all data and repopulate (trying to prevent duplicate data on sheet 5).Please Login or Register to view this content.
Once I know how to detect a blank worksheet I can then prompt the user via a MsgBox.
Edit:
I will be using coulumns "A" thru "Z" only, row numbers will be variable.
Bookmarks