Is worksheet empty (blank)

[Rick_Stanich]

How do you know if a worksheet is empty (blank)? I am using the following code to populate a worksheet.

Please Login or Register  to view this content.

If sheet(5) is not blank I want to delete all data and repopulate (trying to prevent duplicate data on sheet 5).
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.

[royUK]

Something like

Please Login or Register  to view this content.

[dominicb]

Good afternoon Rick_Stanich

Perhaps :

Please Login or Register  to view this content.

HTH

DominicB

[Rick_Stanich]

Some times, the obvious hurts.

Thanks

[Rick_Stanich]

with this new information I modified my code to this.

Please Login or Register  to view this content.

My problem is, if the sheet is blank, the code jumps to the end and reads MsgBox "Operation completed!" with out collecting my data.

I do not see where my error is.

[royUK]

o you want the code to run if the sheet is empty? I would really have thought it would have been easier to just build the deletion of data into the code, maybe with a warning first.

Is this what you want/

Please Login or Register  to view this content.

[Rick_Stanich]

o you want the code to run if the sheet is empty? I would really have thought it would have been easier to just build the deletion of data into the code, maybe with a warning first.

Is this what you want/

Now see what you did? You made me think! Your obviously not aware of the dangers involved with that, black holes collapse, quantum theory is out the window.

Who said this quote?
I became insane with long intervals of horrible sanity!



Turns out it was this easy to fix. Test an either or condition then issue a prompt.

Please Login or Register  to view this content.

Thanks to all!