That did the trick, Paul. Thank you.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.c
EXCEL AND VBA MACROS
Sent: Tue, December 21, 2010 11:43:12 AM
Subject: $$Excel-Macros$$ Determine if dynamic range contains any rows
I have a macro that deletes rows in a dynamic range if certain data
are missing. When this happens, the range obviously has no rows. I''m
trying to write
I have a macro that deletes rows in a dynamic range if certain data
are missing. When this happens, the range obviously has no rows. I''m
trying to write a macro to determine when this has happened.
Basically:
IF the range has no rows THEN
MsgBox "Range has no rows"
ELSE
MsgBox "Range has r
