VBA Syntax Help

[Colin Vicary]

Hi Everyone.

I've reached the extent of my very limited knowledge and I can't fin
the answer in "help" anywhere, so I hope you experts can assist.

I'm trying to select all the rows that have content in row K, I'v
already sorted the row and I'm trying to select them all using the cod
below.

When I enter it, it tells me that I should have included a lis
seperator after "1", can anyone tell me what I should have entere
please?

Thanks

Colin

Dim LastK As Long
LastK = ActiveSheet.Cells(Rows.Count, "K").End(xlUp).Row
Rows(1:LastK).Selec

 

[Frank Kabel]

Hi
try:
Rows("1:" & LastK).Select

 

[Colin Vicary]

Frank

Thanks once again for you help! Your vast knowledge, and you
willingness to share it with others, is amazing.

Thank you

Coli