I have code to trigger a macro once a specific cell is changed, the macro triggers this code:
If there is not at least 2 rows of data in the "Data_Log" range then I get Error 1004. Is there any form of "if" statement I can add to the line of code above to trigger a MsgBox instead of that error?
Please Login or Register to view this content.
Last edited by nohero; 06-30-2011 at 02:54 PM.
nohero,
Something like this?
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Works like a charm, first try. I really wish the forum allowed me to give you back to back +rep since it was 2 separate issues you just helped me with.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks