VBA to find Select next Empty Cell in Column C

Hi all,

I currently have this VBA for a Command Button in a userform..

Please Login or Register  to view this content.

I have tried to do it with the last line but it's not working, All I want the last line to do is Select first empty cell in Column C and make it the active cell.

Please help

Thanks in advance.

Worksheets("Tracker").Activate
Worksheets("Tracker").Range("C" & Rows.Count).End(xlUp).Row+1

Thanks for this,

Its really strange as when I add that in and press enter onto the next line, It removes the + and looks like this..

Please Login or Register  to view this content.

And gives me a debug error on that line.

Any idea's?

What happens if you replace the "+ 1" with ".Offset(1)" (No quotes)

As you have activated sheet "Tracker" you don't need it in line

Please Login or Register  to view this content.

and the expression "Range("C" & Rows.Count).End(xlUp).Row" will give you a number i.e. row number of first empty cell in column C going from the bottom and upwards.

So if you wish to select first empty cell in column C try

Please Login or Register  to view this content.

and if you wish to find the row number of first empty cell in column C try:

Please Login or Register  to view this content.

Alf

Sorry! I lost my internet connection while trying to correct my error.

Try this:

Please Login or Register  to view this content.