Use: Chr$(34) to display a quote mark.
--
Jim Cone
Portland, Oregon USA



"Tony"

wrote in message
....
Almost there. I am getting the formula:
=VLOOKUP(Dungate,BuddyInfo,1,FALSE)
which returns #NAME? All I need now is to add the quote to the lookup value:
=VLOOKUP("Dungate",BuddyInfo,1,FALSE)
Tony



"Jim Cone" wrote:
"=VLOOKUP(" & BuddyL1 & ",buddyinfo,1,FALSE)"
--
Jim Cone
Portland, Oregon USA




"Tony"
wrote in message
I am using the following code to take a value from a master sheet (BuddyL1)
and do a VLOOKUP in the same master worksheet named range (Buddyinfo)
and pick up the First name Initial). This is the cell value I receive when I
enter the cell where the formula eventually resides:
=VLOOKUP(BuddyL1,BuddyInfo,1,FALSE)
This is what I have so far which comes back with a #NAME error:

-snip-
wsPh.Range("e" & Mcnt) = "=VLOOKUP(buddyL1,buddyinfo,1,FALSE)"
-snip-