runtime error, isempty, worksheet change event
I have this macro to round up cells in A column to a multiple of the H column but it is giving me an error when i try to insert a row i know the problem is with the first part I tagged but i don't know hoe to correct it. any help would be much appreciated. i just need the macro to exit if H is 0 so it doesn't try to multiply by 0
Please Login or Register to view this content.Please Login or Register to view this content.
Last edited by Code Flunkie; 01-28-2011 at 05:17 PM.
Hello Code Flunkie,
Here is the amended macro.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
awesome, macro works great. thanks a lot
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks