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 |
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. |
All times are GMT +1. The time now is 03:43 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com