Using variables in a formula

[Arundivakar]

How to use variables inside activecell.formular1c1?

 

[steve the fish]

Just concatenate them in eg instead of:

ActiveCell.FormulaR1C1 = "=RC[1]"

you could have:

myVariable = 1
ActiveCell.FormulaR1C1 = "=RC[" & myVariable & "]"

 

[Arundivakar]

I want to use MID function in activecell.formular1c1. =mid(R1C1,&i&,1) is not working neither is =mid(R1C1,"&i&",1)

 

[RoryA]

Welcome to the forum.

Please at least try to provide a meaningful thread title in future.

You can use something like this:

activecell.formular1c1 = "=mid(R1C1," & i & ",1)"

 

[Arundivakar]

Getting error as "compile error: expected end of statement"

 

[RoryA]

If you get that error with what I posted, you copied it wrong.