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

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

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
.

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
.

.

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
.

.