Using Excel 2010
Hello,
I am using below code to find last empty cell in the column “C” having in the active sheet1.
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
Hello,
I am using below code to find last empty cell in the column “C” having in the active sheet1.
VBA Code:
Sub Find_Last_Cell ()
Range("C" & Cells.Rows.Count).End(xlUp).Offset(1, 0).Select
End Sub
Please suggest a code
Regards,
Moti