Hi folks…. I’m trying to write a piece of code that will insert a formula into a cell. The basic process is that the cell is selected and a button is clicked. A string is created, (containing variables which vary according to the row number of the cell), and then this is inserted into the cell.
I have 2 problems so I’ll use 2 threads…..
I have, through testing, managed to get the string into the cell using;
ActiveCell.Formula = BasicOriginal
Where BasicOriginal is the name of the string, however I can’t seem to find a way of getting the “=” sign inserted at the start of the string so that Excel knows it is a formula.