How to copy values only on same sheet?

[BEEJAY]

How can one copy values only on one sheet, without having to reference an actual sheet name.
All the code I find seems to require the worksheet name to be specified. That will not work for my application.
I've tried numerous variations of the following. When I step thru the macro, no error shows up, but no copying happens either.

Please Login or Register  to view this content.

[tom1977]

maybe this but I only guess

Please Login or Register  to view this content.