Updating ActiveCell.Formula to include Relative Cell Reference

[bellis]

So I have the following script in my macros:

activecell.Formula = "= IF(LEFT($I6,2)=""17"",""CTRL+G"","""")

Instead of $I6, I need to use Offset so I can call the cell needed (and use the formula in mulitple macros). I thought I should edit swap out $I6 with ActiveCell.Offset(1,-12).Value but it's not working. Here is my erroneous code that I'm trying to fix:

ActiveCell.Formula = "= IF(LEFT(ActiveCell.Offset(1,-12).Value,2)=""17"",""CTRL+G"","""")"

How do I change the code to use the Offset feature?

Thanks in advance.
Bruce

 

[JoeMo]

ActiveCell.Formula = "= IF(LEFT(" & ActiveCell.Offset(1, -12).Value & ",2)=""17"",""CTRL+G"","""")"

 

[bellis]

Thanks, JoeMo. I would not have figured that out. When I grow up I want to be like you You are an awesome answerer!

 

[JoeMo]

Thanks, JoeMo. I would not have figured that out. When I grow up I want to be like you You are an awesome answerer!

You are welcome - thanks for the reply.