| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB.Net - retrieve actual formula string
Hi,
I am using VB.Net (Interop) to reference an Excel Workbook, and want to retrieve the actual formula string rathar than the result of the formula. So if the formula in Excel was =SUM(B5:B8) then the string I would want to return would be "=SUM(B5:B8)" I have tried almost every property but still can only seem to get the value. Any help would be much appreciated. Thanks in advance, Grant. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve the value within string? | Excel Discussion (Misc queries) | |||
| Replacing a formula with the actual string or number | Excel Discussion (Misc queries) | |||
| How to retrieve certain char within a string? | Excel Discussion (Misc queries) | |||
| How to retrieve certain text from string? | Excel Discussion (Misc queries) | |||
| How to retrieve certain text from string? | Excel Worksheet Functions | |||
Threaded Mode
