Thread: VBA routine to assign first name only to a variable
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
fitful_thought fitful_thought is offline
external usenet poster
  
Posts: 20
Default VBA routine to assign first name only to a variable
Thanks JulieD,
Works like a charm.

--
Regards,
David

"JulieD" wrote in message
...
Hi David

fname = left(cells(1,1),instr(cells(1,1)," ")-1)

Cheers
JulieD


"fitful_thought" wrote in message
...
Hi,

Cells(1, 1) contains the value
Annette Thompson

How do I get the variable fName to = Annette?

Any help at all will be much appreciated.


--
Regards,
David






Reply With QuoteReply With Quote