establishing last row populated and selecting cells between first and last

Hi,

ive got a spreadsheet with a large amount of data, im trying to automate a button that searches down the column "A" until it hits the end.

i have used the code:

ActiveCell.Value = ActiveSheet.Range("A65536").End(xlUp).Row

this does then do as requested and finds the last row...

What i want then to do is select column "S" between S1 and S[I]n[I] where n is the last row number found above.

Why not just do the procedure on column "S" i hear you cry.. well, column "S" may have data beyond the last row of column "A". I dont want this to be picked up.

Can someone offer me some advice please on how I go about doing the selection?

Many thanks

Iain

You're welcome. Glad to have helped

Seamus

Sorry, Andy, should have noticed that but I'm still learning as well.

Thanks

Seamus