Hi Kerry!
Although the value of variable Rng1A may be wrong, it does not affect the running of the program.
There are only a few reasons for errors
1. target workbook was not opened
2. Wrong target workbook name
3. the value of variable Sh is wrong

Why not upload attachments?


--Okami