Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi
(Can you create code with code within VBA, by the way...?) If you have formulas and links in several worksheets - is there a way - by code or software - to "convert them to vba" to a kind of "library", a fingerprint of all formulas mainly to be able to restore the formulas if you want and when you need. The best is if it create a Sub with a list of all formulas and their cell references as "library". I mean if you in cell A1 has = B1 * C1 it should create a sub that give like: .... Worksheet1.Range("A1").Cell.Value = "=B1*C1" .... ....or something like that for each cell in the workbook. I'm not asking "how to program cell formulas in vba, I ask for a routine to get all links and formulas (values is not of interest) in the workbook. /Kind regards |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
Combining formulas, "and" & "or" to verify content of multiple cel | Excel Discussion (Misc queries) | |||
Trim: Excel 97 gives error "Can't find project or library" | Excel Programming | |||
References.Remove References(1) DOES NOT WORK for "MISSING:" Refs | Excel Programming | |||
"Library not registered" message accessing an HTMLDocument object | Excel Programming |