Code: Select all
=MID(A1,FIND(" ",A1, 1)+1,LEN(A1))
I tried to use this in Word VBA, so that what I paste into my bookmark is just the bit of cell A1 that I want:
Code: Select all
BMRange.Text = Mid(xlWsh.Range("A1").Text, Find(" ", xlWsh.Range("A1").Text, 1) + 1, Len(xlWsh.Range("A1").Text))
Obviously I'd like a fix for this particular issue but can anyone also give me pointers to more general guidance on how to make Excel formulae VBA friendly?
Thanks,
Ken