Using "=" sign in VBA string?

  Simsy 11:21 02 Jun 2003
Locked

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.

I have tried using Chr(61) to no avail.

Thanks in advance,

Regards,

Simsy

  Simsy 12:13 02 Jun 2003

all I had to do was enclose an extra "=" at the start of my code..... I'd tried it previously but had been unsuccessful because of a different error!

Regards,

Simsy

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone