![]() ' Looping through cells and adding it to Bullet lists Set doc = (ThisWorkbook.Path & "/" & docName, ReadOnly:=True) Set theApp = GetObject(, "Word.Application") MacScript "tell application id """" to activate" So my code works, but I'm unable to change it into a Subroutine to call it multiple times throughout the macro A For loop is used to cycle through the dynamic range of cells and insert them one by one in separate bullet points like so:. ![]() ![]() If the cell beside it is empty, the cell from from Step 2replaces the Word bookmarkĤ.b If the cell beside it is not empty, it stores the dynamic range of cells into a variable Goes back to the Excel named range and checks if the cell is empty besides itĤ.a.If not empty, checks if the Word bookmark range exists.Checks if the Excel named range is empty.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |