Hi Dan;

You can use a sub like this


sub try()

'Grab the address for where I am
'this should be the top cell of the column
'you want to select

CellToReturnTo = ActiveCell.Address

Range("A1").Select
ActiveCell.SpecialCells(xlLastCell).Select
MyLastRow = ActiveCell.Row

Range(CellToReturnTo).Select

Range(Cells(ActiveCell.Row, ActiveCell.Column), Cells
(MyLastRow, ActiveCell.Column)).Select

End Sub


Thanks,

Greg


-----Original Message-----
I hope someone can help me out.
I have a column of data with blank gaps for example
somthing like the
following

15
46
55

32
21


48
59

I can manual select the value before the gaps/blank cells
to the value after
the gaps so that they are highlighted and just do a Fill
series function and
excel atuomaticly will interpolate values for the gaps.
However I have a
rather large data set with lots of gaps and it is not
very practical to do
this manualy for each gap in the column of data. I am
have been trying to get
excell to automaticly do this for all the gaps, however
have not found a
method to do this.

Any suggestions or help ?

Dan.
.