Find last cell an another sheet without activating that sheet

[motilulla]

Using Excel 2010

Hello,

I am using below code to find last empty cell in the column “C” having in the active sheet1.

Sub Find_Last_Cell ()
Range("C" & Cells.Rows.Count).End(xlUp).Offset(1, 0).Select
End Sub

Now assume I have active Sheet1…and want to find last empty cell in the column “C” in the sheet2…without activating "Sheet2" how I can do it.

Please suggest a code

Regards,
Moti

 

[motilulla]

So, do you need more help?

Are you saying you want a button on a master sheet that when pressed will take you to the last cell with data in column C?

If not I'm not sure what you want.

Your subject title says:
Find last cell on another sheet without activating that sheet
And do what??
Do you want to enter some data there or what?

Hello My Aswer Is This, thank you for your kindness, yes I need but it is solved as I wanted by @bebo021999.

Have a nice weekend and good luck.

Regards,
Moti

 

[motilulla]

I guess that before running the code, the cursor is randomly positioned on each sheet, possibly anywhere.
You want that when you navigate to a sheet, the cursor is always set to the last row of column C (to facilitate data entry?).
If so, the following code will set the cursor to the desired position:

Option Explicit
Sub Find_Last_Cell()
Dim ws As Worksheet
Application.ScreenUpdating = False
For Each ws In Sheets ' loop every sheets
    ws.Activate ' then activate it
    ws.Cells(Rows.Count, "C").End(xlUp).Offset(1, 0).Select ' select last cell
Next
Application.ScreenUpdating = True
Sheets("Sheet1").Activate ' back to first sheet
End Sub

Hello @bebo021999, thank you for understanding my request and giving a spot on solution VBA worked like magic this is what I was after it.

Have a nice weekend and good luck.

Regards,
Moti