Hello People!
I have a huge formula which I am trying to insert it into a cell using vba.
When the line: Range("E21").formula=".............................................." get executed, it automatically opens the folder picker, once I cancel the folder picker I see the formula gets inserted in cell E21 and calculates correctly. Can anyone guide me why this is happening?
I have a huge formula which I am trying to insert it into a cell using vba.
When the line: Range("E21").formula=".............................................." get executed, it automatically opens the folder picker, once I cancel the folder picker I see the formula gets inserted in cell E21 and calculates correctly. Can anyone guide me why this is happening?