LinkBack URL
About LinkBacks
Hi all,
I need to amend my code to check if shapes exist on my worksheets before the delete.
Because the code below is deleting the selected cell if there are no shapes on the worksheet.
Please Login or Register to view this content.
Hi all,
I need to amend my code to check if shapes exist on my worksheets before the delete.
Because the code below is deleting the selected cell if there are no shapes on the worksheet.
Please Login or Register to view this content.
Try
Please Login or Register to view this content.
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
Hi,
Use the Shapes collection object and count that then test for a count >0
e.g.
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
You both had the same idea.
Works perfect thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks