Application.GoTo Reference

[Jasutasu]

Dear All,

I have been trying to solve the problem by myself, but encountered one problem. I need a macro, which will copy data from a specific range to an another cell, which reference is specified in Cell Y5. Unfortunatelly, the reference in cell y5 is changing all the time, and I wasn't able to extract that reference to the code

The code looks like this:

Please Login or Register  to view this content.

Thanks in advance,
j.

[royUK]

What's in Y5, is a cell reference like $A$1?

[TMS]

It would be something like:

Please Login or Register  to view this content.

Regards

[Jasutasu]

royUK,
Yes, it is like A5

TMShucks,
Thanks! It works smoothly

[TMS]

You're welcome. Thanks for the feedback.