Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using quotation marks
I want to use the following formula in some code:
=and(a20,c2="") but I can't figure out how to use additional single and double quotation marks to surround the existing quotes to make it work. I would use isblank(c2) instead of c2="" but that doesn't work. The spreadsheet has been exported from Access and although the cell appears empty, isblank only works if I highlight the cell, press F2 to edit and then hit enter - so there's soemthing hidden in the cell. If there is a way of forcing the blank cells to really be blank then I could use isblank. Hope this makes sense. Thanks for any help Mike Collard |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using quotation marks
Mike
Use two double quotes ..Formula = "=AND(A10,C2="""")" See also http://www.dicks-blog.com/excel/2004...eet_formu.html -- Dick Kusleika MVP - Excel Excel Blog - Daily Dose of Excel www.dicks-blog.com "Mike Collard" wrote in message ... I want to use the following formula in some code: =and(a20,c2="") but I can't figure out how to use additional single and double quotation marks to surround the existing quotes to make it work. I would use isblank(c2) instead of c2="" but that doesn't work. The spreadsheet has been exported from Access and although the cell appears empty, isblank only works if I highlight the cell, press F2 to edit and then hit enter - so there's soemthing hidden in the cell. If there is a way of forcing the blank cells to really be blank then I could use isblank. Hope this makes sense. Thanks for any help Mike Collard |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using quotation marks
Hi
try something like activecell.formula="=and(a20,c2="""")" -----Original Message----- I want to use the following formula in some code: =and(a20,c2="") but I can't figure out how to use additional single and double quotation marks to surround the existing quotes to make it work. I would use isblank(c2) instead of c2="" but that doesn't work. The spreadsheet has been exported from Access and although the cell appears empty, isblank only works if I highlight the cell, press F2 to edit and then hit enter - so there's soemthing hidden in the cell. If there is a way of forcing the blank cells to really be blank then I could use isblank. Hope this makes sense. Thanks for any help Mike Collard . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using quotation marks
Tried both suggestions already but no good.
-----Original Message----- Hi try something like activecell.formula="=and(a20,c2="""")" -----Original Message----- I want to use the following formula in some code: =and(a20,c2="") but I can't figure out how to use additional single and double quotation marks to surround the existing quotes to make it work. I would use isblank(c2) instead of c2="" but that doesn't work. The spreadsheet has been exported from Access and although the cell appears empty, isblank only works if I highlight the cell, press F2 to edit and then hit enter - so there's soemthing hidden in the cell. If there is a way of forcing the blank cells to really be blank then I could use isblank. Hope this makes sense. Thanks for any help Mike Collard . . |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using quotation marks
Let's test it in the immediate window:
ActiveCell.Formula = "=and(a20,c2="""")" ? activeCell.Formula =AND(A20,C2="") Hmmmm . . . , Seems to work perfectly for everyone else. -- Regards, Tom Ogilvy wrote in message ... Tried both suggestions already but no good. -----Original Message----- Hi try something like activecell.formula="=and(a20,c2="""")" -----Original Message----- I want to use the following formula in some code: =and(a20,c2="") but I can't figure out how to use additional single and double quotation marks to surround the existing quotes to make it work. I would use isblank(c2) instead of c2="" but that doesn't work. The spreadsheet has been exported from Access and although the cell appears empty, isblank only works if I highlight the cell, press F2 to edit and then hit enter - so there's soemthing hidden in the cell. If there is a way of forcing the blank cells to really be blank then I could use isblank. Hope this makes sense. Thanks for any help Mike Collard . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quotation Marks | Excel Discussion (Misc queries) | |||
Quotation Marks? | Excel Worksheet Functions | |||
without quotation marks? | Excel Discussion (Misc queries) | |||
Quotation Marks - When and What?? | Excel Discussion (Misc queries) | |||
quotation marks | Excel Worksheet Functions |