Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening Excel report
Hi,
How do I go about find / replacing all within formulas, a certain cell address which is referenced within individual cells? Any help appreciated. Thanks. fl |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
opening Excel report
Select a single cell to do the whole sheet or select multiple cells to only
do those cells. Edit=Replace Replace What: A1 Replace With: B9 the actual argument should match the appearance of the cell in the formula. If you want code, turn on the macro recorder while you do it manually. -- Regards, Tom Ogilvy fl wrote in message ... Hi, How do I go about find / replacing all within formulas, a certain cell address which is referenced within individual cells? Any help appreciated. Thanks. fl |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pivot table report not valid when opening xls created in 2007 | Excel Discussion (Misc queries) | |||
Getting missing data from one report into another report... | Excel Discussion (Misc queries) | |||
Automate Excel report to place certain data into existing report? | Excel Worksheet Functions | |||
"Unable to read file" error message when opening a Excel file that contains a PivotTable report. | Charts and Charting in Excel | |||
REF errors when opening excel in xp. works fine when opening wor. | Excel Discussion (Misc queries) |