hello,

I'm trying to enter in a search formula in vba, but i'm having troubl
with the syntax because i'm using 2 sets of parentheses.

Range("A1").Formula = "=SEARCH(" ",B1,1)"

there is a problem because i want to search for the first space in
sentence, but in the editor, it is recognizing the first two set o
parentheses and then the second set, expecting me to concatenate th
two strings. how can i fix this? Thank

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