Last row containing data in specified column.

[mysterious-dr-x]

I don't even know where to start with this & the internet has been no help at all, so sorry for the lack of any code.

What I want to do is find the last row containing data in column C, this wouldn't cause a problem for me if it wasn't for the fact that filled cells in column B continue much further.

Help plx.

 

[VoG]

Is this in a formula or VBA?

Does column C contain numbers or text?

 

[mysterious-dr-x]

Is this in a formula or VBA?

Does column C contain numbers or text?

VBA & numbers.

 

[VoG]

Try

Dim LR As Long
LR = Range("C" & Rows.Count).End(xlUp).Row

 

[mysterious-dr-x]

Try

Dim LR As Long
LR = Range("C" & Rows.Count).End(xlUp).Row

That is so simple it should have been obvious, sadly it wasn't so thank you.

btw, can you use any letters you want for that, or does it have to be LR?

 

[VoG]

Anything you like, as long as it is a valid variable name.