| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change a formula in VBA
Can anyone help with this problem:
I am trying to write a macro to change a formula in a cell and place the new formula in the same cell. For instance: Cel L1 in a worksheet contains: ='C:\TEST\[file.xls]data'!J7 By hand I can change this in: = TRIM('C:\TEST\[file10.xls]data'!J7) which removes excess spaces. How must I do this in a macro? Thanks in advance MahrYon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change formula in a shared worksheet without losing change history | Excel Worksheet Functions | |||
| how to change formula in shared sheet without loss of change histo | Excel Worksheet Functions | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| How does Data Validation change with a formula change? | Excel Worksheet Functions | |||
Threaded Mode
