X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Loop Through Range And See If Shape Exist, Office 2010    
post May 19 2020, 11:19 PM

Posts: 1,359
Joined: 17-November 13
From: Orewa New Zealand

I have 2 worksheets Sheet2 and sheet3
sheet2 has alot of named shapes on it
sheet3 in column A has the shape name

I want to starting at the last row of sheet3 and go up check if shape name exists in sheet2 if it does not then run some code if it does then exit

this is the code that I want to run on each row that name is not found
the TaskID will = the name in column A of the shape name thats not found

.Shapes("Sample").Duplicate.Name = TaskID 'Create New task Shape & Assign Name
This post has been edited by wornout: May 19 2020, 11:34 PM
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    6th July 2020 - 06:36 PM