Thread
:
Formula to equal Blank
View Single Post
#
3
Posted to microsoft.public.excel.programming
Chip Pearson
external usenet poster
Posts: 7,247
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
Reply With Quote
Chip Pearson
View Public Profile
Find all posts by Chip Pearson