Formula in macro not working

[stephen antoine]

Can someone please let me know what is wrong with the following?

ActiveCell.Formula = "=" & ActiveCell.Offset(-2, 0).Address(0,0) & "-" & ActiveCell.Offset(-1, 0).Address(0,0)

I can't figure out why I'm getting an error

Thanks

 

[Jonmo1]

It would error if your current ActiveCell is in Row 1 or 2, since ActiveCell.Offset(-2,0) would try to go to row 0 or -1...

Other than that, it works fine for me..

 

[Norie]

Stephen

What's the active cell when the code runs?

If it's anything in row 1 or 2 then the code will error.

Perhaps you should post the rest of the code and explain what it's purpose is.

 

[stephen antoine]

OMG I'm an idiot!!!

Thanks, I was racking my brain on this yesterday. I guess I was just fried or something....

Thanks again

 

[stephen antoine]

No, Jonmo1 got it...I was trying to offset rows when I actually needed columns...

Thanks for your reply...

 

[Jonmo1]

See my signature....LOL.

 

[stephen antoine]

Amen to that!!!

Thanks for your hep