Returning to initial worksheet after Macro changes worksheet

[Peterhmg]

Hi Folks,
I have a macro that hides certain rows in each of 4 worksheets. Currently it always remains on the last worksheet that was selected. I would like it to return to the worksheet from which the macro was invoked - it could be any of them. I just don't know enough about this VB stuff..... Any ideas?

Regards,
Peter

[Philb1]

Got an example workbook?

[TMS]

Well, two ways.

1. Define a worksheet object variable and use, say,

Please Login or Register  to view this content.

. Then, at the end, use

Please Login or Register  to view this content.

2. Don't select the worksheets. Use With ... End With to create a "With block" and then refer to the cells/rows/columns using the reference. Much more efficient.

[Peterhmg]

Got an example workbook?

Yes, but I don't know how to attach or send it.

Peter

[Peterhmg]

The Set.WSa works well - thanks.

I will try the second recommendation sometime!

Regards,

Peter

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

[Philb1]

Yes, but I don't know how to attach or send it.

Peter

Hi peter
Go advanced, click the paper clip icon & follow the prompts is the way it's supposed to work. I haven't been able to upload a file here for months now coz it doesn't work, I have to click the link icon & use a dropbox link