Thread
:
Formula to equal Blank
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
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
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]