Hi everyone!
I am having trouble figuring out how to use the method .Find... What I am trying to do is search column("A:A") for the first instance of a string contained in a variable. If found then insert a row above it pushing everything down) and populate that row with Data (Value in column B tells you the version... so version that got pushed down +1). If it doesn't find anything then insert a row at 2 (pushing everything else down) an populate it.
I have managed so far:
The problem is that the rows get shifted down and then work is being carried out below the data instead of on top...Please Login or Register to view this content.
In the example attached: If user searched for Project "Other Project", then shift everything down from row 5 and add one to the version
It also crashes if the string is not found and I am not sure how to handle the error and start at the top (row 2) with a fresh line and version 1.
The code gets executed from a different file where all the data is contained.
Many Thanks!
Bookmarks