Hi,
The attached file works fine on excel 2007 but on excel 2003 it stops after the first IF statement even if both IF statements are true. And it doesn't carry on after the ifs to put in the cell values below the second if?
Any thoughts??
The Password to Unprotect and enter the macro's is 'PLEC'
With all that code in the book & buttons etc I can not tell what If statements you are refering to.
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Sorry the "Comm_Find" Macro which is called when you press the 'Calculate' Button.
John
when only one row selected the Comm_Find macro will crash on the 2 commands in red within this section of the macro. It cannot set the insidehorizontal properties when there are none to set
Please Login or Register to view this content.
Try this modification
Please Login or Register to view this content.
Last edited by mudraker; 04-27-2007 at 11:00 PM.
Thanks,
Sort of figure it out but thought that excel 2000 must not support that command. thanks for clearing it up!!
Jon
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks