Thank you in advance for any help.
I am getting a mismatch error when I am trying to define a range with lastrow. This code is meant to 1. Search for the word "True" in Column P 2. If "True" is found then copy columns A:O from the active row that "True" was found on 4. Delete that range only and shift cells up 5. Paste the range to the first blank row on another sheet. I have added an example workbook to this post for clarity.
This line seems to be giving me the Mismatch Error
and this most likely
I thought I defined the range properly and then referenced the rng & lastrow in the area I am trying to cut. I am just not sure what I am doing wrong. Here is the code:
Thank you again for any help.
Bookmarks