What I am trying to accomplish w/ this snippet of code is to find the right hand side of the table in my worksheet and clear the contents of the columns to the right of the table. I have marked where my error is cause in the code. If there is an easier way to do this it would be welcome.
Thanks in advance,
Please Login or Register to view this content.
Could you please upload a sample workbook
In the attached file that is what I am left with after the reconciliation. I need to clean up...i.e delete what remains to the right of the table.
Change Columns to ListColumns.
If posting code please use code tags, see here.
That worked. I no longer get an error, but it's not achieving the desired result. Any suggestions?
What is the desired result?
In the example file are you trying to clear columns O and P?
The desired result is to clear columns to the right of the table. The data to be cleared will not always be in those two columns so it needs to be a dynamic reference.
That's a one liner:
Option Explicit
Please Login or Register to view this content.
If that's too hard to read, you can add a couple of variables and go piece-by-piece.
Please Login or Register to view this content.
Your first error, was using .columns.count (instead of .ListColumns.count).
Last edited by GeneralDisarray; 07-28-2015 at 04:00 PM.
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
Try this...
Please Login or Register to view this content.
GeneralDisarray - Worked like a charm, thank you very much!
No problem, I added another version for clarity (just unpacked that one line into multiple steps).
Please mark your thread as solved :D
Another...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
GeneralDisarray - If I may ask, what is the difference between columns.count and listColumns.count?
ListColumns is a valid object of ListObject, Columns is not.Originally Posted by bdueck
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks