Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute paste link
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. -- Boris |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
absolute paste link
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Spreadsheets are cut off when you paste and link? | Excel Worksheet Functions | |||
Macro: Copy and Paste Boomberg Link | Excel Discussion (Misc queries) | |||
Paste Link Function | Excel Discussion (Misc queries) | |||
Paste Link enters a 0 into the cell where I paste. How do I elemin | Excel Discussion (Misc queries) | |||
Paste a chart as a link? | Charts and Charting in Excel |