How to activate a past activecell

I am writing a macro which uses a loop to find a certain cell and then it copies the cell to the left and pastes it on another sheet, but when it goes to paste on another sheet a new cell is activated. I need the macro to keep looping on the initial sheet but now that cell (copied from) is not active anymore. How can i make it so the macro remembers that initial cell (on initial sheet) and continue the loop from there?

It would help to see the code. You almost never need to select or activate anything in code anyway.

Try this:

Please Login or Register  to view this content.

not picking up the right cells for some reason, but that's a much nicer code! thanks!

I'll try adjusting it so I can get it to pick up the right numbers (relating to "Z").

edit: needed to change .Offset(0, -8).Value to .Offset(n, -8).Value, working perfectly now!!! thanks so much!

Yep, well spotted. Sorry about that!

I think it needs a slight amendment

Edit: Romper replied whilst I was looking at it

Please Login or Register  to view this content.