I would like to add the following VBA to my macro: Have it go down column D and if the word "Dog" is found(this will be the first cell of a table), I would like to it to put a border around the entire table.
I would like to add the following VBA to my macro: Have it go down column D and if the word "Dog" is found(this will be the first cell of a table), I would like to it to put a border around the entire table.
![]()
Please Login or Register to view this content.
Hope that helps,
~tigeravatar
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
That works, Thanks. I see that I have a couple tables where "Dog" starts the second row of the table. Is it possibile to start the border from that point and not include the cell above it. So from "Dog" right and down until "". Thanks
color and border all in one would be nicehope mrexcel enjoys it also
http://www.excelforum.com/excel-prog...olor-fill.html
http://www.mrexcel.com/forum/excel-q...olor-fill.html
If solved remember to mark Thread as solved , to mark your thread as Solved select Thread Tools and click Mark thread as Solved.
I can't read the mind of my wife so then I get picture but no sound .... and then I mostly get the idea, same goes here picture your outcome and I get the idea.
![]()
Please Login or Register to view this content.
Thanks. That works.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks