So, it will be pretty obvious how new I am when you look at my unconventional code, but the code has worked perfectly up until I copied what I thought was a solution off of the forum. Daily I process a file that has some extreme formatting. This is a tiny piece of the pie. I am trying to find the word "BALTIMORE" and cut the entire row(s) that contain the selection and paste/insert the rows just above the first row with the word "THURMONT" in it. My code only works if BALTIMORE is found but hangs when it is not found. I would also like to insert 2 blank rows above insertion point. Thanks in advance for any pointers.
Please Login or Register to view this content.
Bookmarks