I need VBA to add to my macro to have it go down column D and have border put for 1st cell with data and border down until no more data and keep going down column D and doing the same thing. This first cell in column D with data will always start with Cat and the last row in the string will be Total. I don't want to do the whole table, just down border down column D. Thanks.
Try
Please Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Give this a try:
Please Login or Register to view this content.
Gary's Student
You can also do that with conditional formatting. Select Column D and use: =$D1<>"" and specity border...
Ben Van Johnson
Assuming that Gary's Student's interpretation that you want an outside border around the whole range (I wasn't sure by your question (and I'm still not)) you can also try
Please Login or Register to view this content.
Thanks for the help. Looking at all the tables, some are not the same. Can I make it go from "Total" in first cell in D and go don't until "" 1st blank cell and only do an outside border only? Thanks for help.
Are you saying from D1 to last used cell in Column "D"?"Total" in first cell in D and go don't until ""
here is what im looking for. thanks so much
Just knocking off for the night but I'll post this until someone comes up with something better
Please Login or Register to view this content.
That's it, your awesome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks