View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default Replace Space charcter in a string variable

Hi Pikus
Replace works also on string variables (see VBA help)

--
Regards
Frank Kabel
Frankfurt, Germany


He specifically said he was working with a string variable, not info
in a cell. Now the info may actually be in a cell, but without
knowing I didn't want to assume. That being said, Replace only works
on Range objects right? So it wouldn't work with a string... Please
tell me if I'm wrong about that. - Pikus


---
Message posted from http://www.ExcelForum.com/