Getting a Compile error: Invalid use of property.
The word Borders in the line: .Borders (xlEdgeBottom) highlighted blue.
How to resolve the error?
Please Login or Register to view this content.
Getting a Compile error: Invalid use of property.
The word Borders in the line: .Borders (xlEdgeBottom) highlighted blue.
How to resolve the error?
Please Login or Register to view this content.
Move it up to the end of the prior line.
Entia non sunt multiplicanda sine necessitate
Hi Phil,
Try this:
Please Login or Register to view this content.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
shg, There is a misnomer here - we are not dealing with an "double underline," but rather a double bottom border. "Underline" is for the benefit of users. I did as you suggested and the error cleared; however, the double bottom borders are not changed to the single border. Nothing is happening. What next?
Please Login or Register to view this content.
Double underline? Text underline or borders?
Please explain what you're trying to do.
This is from an accounting worksheet. Two columns hold spending entries. Periodically during the month these entries are reconciled against a bank statement. If the last spending balance agrees with the bank, clicking a shape with an attached macro makes a double bottom border, indicating balance.
At the end of the month, the worksheet is copied to create the worksheet for the next month, and the double bottom borders must be changed back to single bottom borders.
Last edited by Phil Hageman; 04-03-2015 at 07:19 PM.
Pardon?
How does this relate to your original question? Have we solved that problem and moved on to something else?
Last edited by shg; 04-04-2015 at 12:25 AM.
I think I have confused two threads. I need to resolve the original issue with the error on the double bottom border macro.
See post #5.
Hello Phil Hageman,
Try this...
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 Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Folks, I tried the code in #3 by Marvin and it works, as far as it goes. My logical mistake was that when changing a border in a range, the interior borders are changed, not the edge borders. In this case, the top and bottom edge borders where being changed, which doesn't work in a range.
Sorry for all the runaround trying to get this done. Appreciate all your time and effort.
Last edited by Phil Hageman; 04-04-2015 at 07:49 AM.
Should be
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks