Help with find and replace macro
bhofsetz wrote:
Dave,
You are getting the error message on this line
rOldHds.Select 'TEMP
becase the workbook and worksheet on which you are trying to select
that range are not the active book and sheet.
You would either have to manually select that book and sheet or do it
in the code with:
HeadersBk.Sheets(1).Activate
then
rOldHds.Select 'TEMP
I also noticed that you are counting rows on Sheet(19) and then
selecting the range on Sheet(1). Is this correct?
Thanks! It's working fine now.
|