Make a cell forumla equal a text string

[HeebieGeebie]

Hi there,

I am trying to create a dynamic formula. I have written a simple bit of VBA that adds text strings together to create a formula (as a text string). Now all I want to do is use the forumla in a range. The final formula is output as a text string in cell G11. I now want the range F3:F367 to actually use the formula.

I thought this line: " Sheets("Daily").Range("G12").Formula = G11 " would output the text as a formula in cell G12, but it is just blank.

Please Login or Register  to view this content.

Any help greatly appreciated!


Thanks,

Adam

[:) Sixthsense :)]

May be try like this...

Please Login or Register  to view this content.

[HeebieGeebie]

Awesome! That worked - I just had to remove the ' "=" & '

It now looks like this:

Please Login or Register  to view this content.

Thanks a lot SixthSense!!