Hi everyone,
I have found below mentioned code which loops through all excel tables in a workbook to get something done. Initially the code works but when I try to edit to fill my needs then it doesn't work. I am unable to link column named "Doc Date" in all excel tables. I want to delete contents of column "Doc Date" in all tables in the workbook and it is giving me error. Kindly help in this regard.
Original sub is as below.
Please Login or Register to view this content.
Last edited by loverfellow; 12-01-2015 at 10:20 AM.
How are you trying to delete the column?
Will the column you want to delete be present in every table?
If posting code please use code tags, see here.
I want to clear contents of header column of "Doc Date" in every table. And yes the column will be be present in every table.Originally Posted by Norie
You don't say what you tried or how it didn't work but this worked for me.
Please Login or Register to view this content.
Thanks a lot buddy, it worked for me too.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks