This code is supposed to clear the contents of row 6 cell if the contents of row 5 cell is blank/cleared. I get an error on the "If Intersect" Line. What's wrong?Thanks in advance.Please Login or Register to view this content.
This code is supposed to clear the contents of row 6 cell if the contents of row 5 cell is blank/cleared. I get an error on the "If Intersect" Line. What's wrong?Thanks in advance.Please Login or Register to view this content.
Last edited by ChemistB; 09-15-2009 at 04:04 PM.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Hi,
intersect returns the overlap of the two ranges. You need to test it for its contents..
Try replacing this
with thisPlease Login or Register to view this content.
Please Login or Register to view this content.
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
Thanks Dave,
That helped (no more error messages) but now, the code is clearing the value in row 6 whether or not there is a value in row 5. It is ignoring the IF seemingly.
...because neither of us are testing for it. Sorry - been a long day
Please Login or Register to view this content.
Duh, it has definitely been a long day. Sheesh. Thanks Dave.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks