reference adjacent cells in formulae

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Insert Row also adds formulas and moves cursor 2
Named Range maker code 9
Identify adjacency cells with same value 3
Problem with a loop and column references 27
Keeping formulas on an insert 1
How do I reference cells in CF formula within loop 2
Insert Row and Formula 1
Cell Address References won't update when Sorting 2

Back
Top