| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
reference adjacent cells in formulae
I have a macro which loops till a criteria is met. I then want it to insert a
formulae using the two cells immediately to the left of the active cell. Then it will continue to loop until the criteria is met again and the formula again inserted. How can I get the macro to reference those cells to the left in the same row. Below is what I currently have with a "?" being the row that I am currently in. I have tried using "#" and a combination of Offsets without much joy. ActiveCell.Offset(0, 8).Select (being Column "I") With Selection .Formula = "=$G?-$H?" End With |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add cells on two adjacent rows but non-adjacent columns | Excel Worksheet Functions | |||
| How to map cells to a reference then copy adjacent ones | Excel Discussion (Misc queries) | |||
| Set formulae to read the adjacent or next spreadsheet | Excel Worksheet Functions | |||
| displaying adjacent cell when using max/min formulae | Excel Worksheet Functions | |||
| How can I autofill a series to reference non adjacent cells? | Excel Discussion (Misc queries) | |||
Threaded Mode
