hi,
below code does the job nicely of deleting the empty rows in word document. Need help in tweaking this code to delete the empty rows with bookmark as well. Please assist.
Please Login or Register to view this content.
hi,
below code does the job nicely of deleting the empty rows in word document. Need help in tweaking this code to delete the empty rows with bookmark as well. Please assist.
Please Login or Register to view this content.
Keep the Forum clean :
1. Use [ code ] code tags [ /code ]. It keeps posts clean, easy-to-read, and maintains VBA formatting.
2. Show appreciation to those who have helped you by clicking * Add Reputation below their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
It would be helpful if you said what the bookmark applies to (e.g. a whole table, a whole row or column, multiple cells, a single whole cell, text in a cell); it would be even more helpful if you posted structured code...
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Hello,
As i am creating a table with each table field to be filled with different data from excel, the bookmark that i did is around 68 in order to achieve this. This is the code above that i pasted is the code that does the job of deleting all blank cells from table. But as i have bookmark in it, it doesnt consider it has blank and hence doesnt it.
Do let me know if am still confusing
Thanks
Your understanding of bookmarks is erroneous; they don't occupy any space and are incapable of causing your macro to consider as cell to not be blank. You should check what else is in the cell. It's also not apparent why you need bookmarks to populate the Word table.
This word attached can help to put us on same page. As you can see, for each letter preparared second page will have this section. With help of book mark, i can increase or decrease the content. Later part i want to delete blank cell.
With above macro i posted, it doesnt delete the cell, unless i remove the bookmark ( By pressing select and pressing delete button). When i do that book mark gets deleted and when i run the macro, the empty rows get deleted.
As I suspected, you have other content in every cell - an unnecessary non-breaking space.
Oh.. am so sorry.. I didnt even get hitch of it. Sorry to waste your time, my apologies.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks