Formula to equal Blank
 

How can I enter the forumula

="="

with a VB script

When I enter it the VB script automatically changes it to

" =" = " "

I want to enter Range("K2").FormulaR1C1 = "="= but I guess
this must be arranged in quotes. If I don't put them in I
get an error and when I do it splits it up

Any help please

Jacqui

Formula to equal Blank
 

range("k2").formula="=whateverformula"

--
Don Guillett
SalesAid Software
Granite Shoals, TX

"Jacqui Hurst" wrote in message
...
How can I enter the forumula

="="

with a VB script

When I enter it the VB script automatically changes it to

" =" = " "

I want to enter Range("K2").FormulaR1C1 = "="= but I guess
this must be arranged in quotes. If I don't put them in I
get an error and when I do it splits it up

Any help please

Jacqui

Formula to equal Blank
 

Jacqui,

Try the following

Range("K2").Formula = "=""="""

Whenever you need to include a quote (") in a string in VBA, use a
pair of quotes ("").

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Jacqui Hurst" wrote in message
...
How can I enter the forumula

="="

with a VB script

When I enter it the VB script automatically changes it to

" =" = " "

I want to enter Range("K2").FormulaR1C1 = "="= but I guess
this must be arranged in quotes. If I don't put them in I
get an error and when I do it splits it up

Any help please

Jacqui

Formula to equal Blank
 

Worked it out.

I used the ascii character codes.

Sorry to waste anyones time.

Jacqui
-----Original Message-----
How can I enter the forumula

="="

with a VB script

When I enter it the VB script automatically changes it to

" =" = " "

I want to enter Range("K2").FormulaR1C1 = "="= but I
guess
this must be arranged in quotes. If I don't put them in I
get an error and when I do it splits it up

Any help please

Jacqui
.