View Single Post
 
Old 02-21-2023, 06:54 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Nicole
Quote:
identify if there is anything in document following the point where you are about to insert the macro?
Your question is clear enough to be answerable. VBA code can identify almost anything in the document but 'insert the macro' doesn't mean much. Perhaps you mean at the point where the selection object is sitting when you start the macro.

Maybe try telling us what it is that you want to do and what the user will need to do before triggering the macro.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote