| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Countif a corresponding value is not equal to zero or blank | Excel Worksheet Functions | |||
| Formula to find equal values with blank cells | Excel Discussion (Misc queries) | |||
| Why does blank text equal 0? | Excel Worksheet Functions | |||
| I don't want blank tp equal zero | Excel Discussion (Misc queries) | |||
| Blank (empty) cell always equal to 0?? | Excel Discussion (Misc queries) | |||
Linear Mode
