| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Sheet Cell Formula Reference
I have two issues both similar:
1) I have a number of columns, one of which has a formula with a Sheet!Cell reference in the formula. I want to change the Sheet reference to another sheet and previous the rest of the formula in that column. For example: Old Sheet Name: DoThis New Sheet Name: GoHere --- Can some loop be constructed using For Each in maybe a VB module which would do this? If so what is the object name and how would I do it? ---- Is there an easier way? ================ 2) Basically the same issue, except the link is in another workbook. I want to remove the linked workbook and move the single sheet on the Workbook to another Workbook with multiple sheets? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy an exact formula without changing cell reference | Excel Worksheet Functions | |||
| how to reference a changing 'last row' cell in a formula | Excel Programming | |||
| Changing sheet reference to cell reference | Excel Worksheet Functions | |||
| A cell reference in a formula changing | Excel Worksheet Functions | |||
| HOW DO I COPY FORMULA WITHOUT CHANGING CELL REFERENCE | Excel Discussion (Misc queries) | |||
Threaded Mode
