I have a macro that copies the contents of sheet A to sheet B. Everything else goes fine but I'm not able to move the freeze panes setting. For example, if there's cell D5 freezed in the sheet A, the macro should set the same cell freezed also in the sheet B.

I cannot move or copy the whole sheet, which would solve the problem. I can move or copy only the contents of the sheet.

The 'ActiveWindow.FreezePanes = True' command in the sheet B sets the right setting but to a wrong cell.

So basically my problem is that I'm not able to find the right cell in the sheet A. If I could do that, it would be easy to choose the same cell in the sheet B and then use the command above.

Anyone, any ideas? Thanks in advance!