| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A formula that evaluates the value of a cell relatively addressed.
Never posted before...
If you please.... I have the following working formula in cell H69 (for example): =IF(D69=0,"","Limit") When D69 equals zero, H69 is blank, otherwise it shows the string "Limit". A macro will assign this formula to a particular cell and it won't always be row 69. How can I replace the D69 with something akin to "current column minus 4" & "current row"? The VBA is ActiveCell = <the formula above Thanks for any ideas! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How a cell can be addressed with variable file-column? | Excel Discussion (Misc queries) | |||
| Please help - formula works in some cells but evaluates to #value in others | Excel Worksheet Functions | |||
| questions being addressed | Excel Worksheet Functions | |||
| Simplifying array formula which evaluates as error. | Excel Worksheet Functions | |||
| Can I create a formula in Excel that evaluates form information? | Excel Worksheet Functions | |||
Threaded Mode
