Need to add sheet in my 'SELECT RANGE' code

[Sarangsood]

In the following code i need to add the name of the sheet 'SHEET1' so that if i am on any other sheet , the code selects only sheet1 .

Please Login or Register  to view this content.

[Olly]

Put

Please Login or Register  to view this content.

before line

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

[millz]

Add this at the top?

Please Login or Register  to view this content.

[fr0zenfyr]

I'm not really sure what you want.
This code will rename the sheet

Please Login or Register  to view this content.

Replace mySheet with the name of your sheet.

If you are on a different sheet and want to run the macro on a sheet named "SHEET1", use this code

Please Login or Register  to view this content.

Alternatively, you can select the sheet by

Please Login or Register  to view this content.

[Sarangsood]

i used the code

Please Login or Register  to view this content.

this code sends me back to sheet1. i want to keep working on another sheet while the macro keeps running on sheet1.

[millz]

i want to keep working on another sheet while the macro keeps running on sheet1.

Well, then try the example by Andy Pope

[Sarangsood]

yea that worked perfectly . also it freezes my sheet for that particular time when the macro of andy 'Speakcells' is running. can something be done about it ?
thanks everyone

[Andy Pope]

You can not use excel whilst code is running.

What exactly are you trying to do? Perhaps a count down of some sort?

[Sarangsood]

yes this is how the code looks now

Please Login or Register  to view this content.