OK thanks, now I realise where my question lacked one vital piece of
information,

there is no data in the column, the column to the left and the column to the
right have data but I want to select down to that last row of data to
autofill in a formula.

on one spreadsheet it may be 5 rows of data dn another it may be 25.

I need to find out how many rows there are then autofill the formula that
amby rows

thanks

thanks

"Jim Thomlinson" wrote:

Does the Column have formulas in it that are returning "". That Key combo
whould select up to the first blank cell. Similar in code to
Range("A1).End(xlDown) which goes to the last populated cell in before a
blank cell in column A.
--
HTH...

Jim Thomlinson


"Nigel" wrote:

There are key combinations to select the the data from a cell to the end of
the spreadsheet, are there any key combinations to select all the data in a
colum, not the whole column just down to where the data ends

thanks