Macro to perform actions in passive sheet

[Jovica]

I've got this code and I would like if it's possible to activate it without activating sheet "BT+"
I've tried with "With Sheets("Sheet Name")" instead of "
Sheets("BT+").Select" and it doesn't work.

Please Login or Register  to view this content.

[AB33]

You can use With and End and no need to select the sheet as long as the sheet is on the same workbook. You also have set long as range (r2 ). I do not know what are you trying to do on this line

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[Jovica]

I've got compile error with your code (Expected Sub...), anyway I've tried

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

and it doesn't work (it does not perform those actions in sheet (BT+) but in active sheet.

[AlphaFrog]

Try this...

Please Login or Register  to view this content.

[Jovica]

Thanks for quick reply. Previous code was trying to find first empty cell in column C not first cell after C2. Last macro overwrites previously entered data.

[Jovica]

It does work, I've just changed C2 to C3 (C2 is empty cell).

Thank you so much.