On Tue, 12 Jun 2007 06:16:00 -0700, CWillis
wrote:

I am inserting formulas into cells using a macro. Several formulas require a
blank. (" ")


Others have posted the solution. However, a word of caution. With your " "
you are NOT inserting a "blank", rather you are inserting a <space character.

If you want to insert a null string, which is generally what is meant when
someone writes about inserting a blank, you should not include the <space.

So instead of "" "" you should be using """"
--ron