Hi guys,
I have done a macro automation and now I am stuck in one place.
Its an excel macro where I have some data on multiple cells and with that I automaticallt open a word template and updates excel cell information in the bookmarks placed in the document. VBA already does this everything. But the challenge now is the excel VBA should check if my 17,18 &19th line of the word document is empty n if it is empty then delete those lines. If any one of these lines also empty then delete those lines.
ple suggest
I have done a macro automation and now I am stuck in one place.
Its an excel macro where I have some data on multiple cells and with that I automaticallt open a word template and updates excel cell information in the bookmarks placed in the document. VBA already does this everything. But the challenge now is the excel VBA should check if my 17,18 &19th line of the word document is empty n if it is empty then delete those lines. If any one of these lines also empty then delete those lines.
ple suggest