Too early in the morning to answer first question. Don't fully grasp what you
want.

For second question..........

Sub Absolute()
Dim cell As Range
For Each cell In Selection
If cell.HasFormula Then
cell.Formula = Application.ConvertFormula _
(cell.Formula, xlA1, xlA1, xlAbsolute)
End If
Next
End Sub


Gord Dibben MS Excel MVP

On Wed, 6 Dec 2006 16:19:00 -0800, BorisS
wrote:

I need to grab several non-adjacent rows and paste-link them to another part
of a sheet. Any way to do this? Or is there a way to mass-convert a set of
cells (which are the pastes, without absolute) to be absolute references?

Thanks.