Absolute ref from relative in VBA

I want VBA to insert a formula into the current cell which has an absolute reference to one cell and a relative to another. I tried recording something & got the following:

Please Login or Register  to view this content.

This does get me absolute & relative references, but the absolute is hard-wired into the macro. I want to create an absolute reference from a relative one. I tried the following:

Please Login or Register  to view this content.

This resulted in an error. I want to use the macro regardless of what the active cell is, and always end up with a relative reference to the cell to the immediate left, and an absolute ref to the cell immediately above the active cell.

Any help appreciated.

Hello gjcase,

Rather than trying to explain the problem using formulas, try using cell addresses. Provide before and after examples of with details of what should happen with the addresses and what they should look like.

Hello gjcase,

Is this statement correct or should it have been H14 instead of H1?

If the current active cell is H14, on executing the macro, I want H1 to contain the formula

Hello gjcase,

This should do it.

Please Login or Register  to view this content.