Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a link to a value
How do I convert a link to a value on a worksheet basis. I have other sheets
that I want to keep the links on for the time being. As I understand the "break links" option beaks the whole workbook. Mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a link to a value
Hi Mike,
Manually you could edit every single cell by pressing F2, selecting the link, and then pressing F9, which calculates the value, and at eventually press Enter in order to place this result in the cell. But problably this isn't what you are seeking for in this group. In code you could replace the complete formula in every relevant cell by its value, somewhat like this: Dim MyRange as Range, MyCell as Range For Each MyCell in MyRange MyCell.Formula = MyCell.Value 'mind the data types involved! _ and maybe this should read somewhat like: _ "=" + MyCell.Value Next If not the complete formula has to be replaced by its value, you should replace only part of it, by analyzing it before. I hope this helps a bit! Greetings, Peter "Mike K" wrote: How do I convert a link to a value on a worksheet basis. I have other sheets that I want to keep the links on for the time being. As I understand the "break links" option beaks the whole workbook. Mike |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Converting a link to a value
same thing copypaste special pastevalues,but can only do one cell at a time..
-- paul remove nospam for email addy! "Peter_A_M (NL)" wrote: Hi Mike, Manually you could edit every single cell by pressing F2, selecting the link, and then pressing F9, which calculates the value, and at eventually press Enter in order to place this result in the cell. But problably this isn't what you are seeking for in this group. In code you could replace the complete formula in every relevant cell by its value, somewhat like this: Dim MyRange as Range, MyCell as Range For Each MyCell in MyRange MyCell.Formula = MyCell.Value 'mind the data types involved! _ and maybe this should read somewhat like: _ "=" + MyCell.Value Next If not the complete formula has to be replaced by its value, you should replace only part of it, by analyzing it before. I hope this helps a bit! Greetings, Peter "Mike K" wrote: How do I convert a link to a value on a worksheet basis. I have other sheets that I want to keep the links on for the time being. As I understand the "break links" option beaks the whole workbook. Mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Converting a date to a text field w/o converting it to a julian da | Excel Worksheet Functions | |||
PASTE LINK option not available when I select PASTE SPECIAL to link an image in Excel to a Word document. | Links and Linking in Excel | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
if i sort cell that has link to another page how to keep link | Excel Discussion (Misc queries) | |||
Converting a link to values to multiple cells. | Excel Worksheet Functions |