Hello,
I am a bit stumped trying to figure this one out and would appreciate any assistance. I am looking for a VBA script that will look through column A for any cell containing the strings year OR years but not "("" (their position within each cell will differ), and deleting that row if found. For example, in the below the first row/cell would be deleted. Many thanks.
I am a bit stumped trying to figure this one out and would appreciate any assistance. I am looking for a VBA script that will look through column A for any cell containing the strings year OR years but not "("" (their position within each cell will differ), and deleting that row if found. For example, in the below the first row/cell would be deleted. Many thanks.
13 Years |
2012-2014 (2 years) |
2011-2012 (1 year) |
February 2008 - March 2009 (1 year 1 month) |