pasting right hand chars copied from XL

[stuck]

In Word VBA the line:

Code: Select all

ActiveDocument.Bookmarks("bmkNUM").Range.Text = xlWsh.Range("A1").Text

puts the contents of cell A1 of an XL workbook into my document at the designated bookmark but cell A1 holds a string and I only want the right hand end of it.

Please can I have some pointers to how I can extract just the bit of cell A1 I want?

Thanks,

Ken

[HansV]

If you want to extract, for example, the last 3 characters from the text in cell A1, you can use

ActiveDocument.Bookmarks("bmkNUM").Range.Text = Right(xlWsh.Range("A1").Text, 3)

[stuck]

Ah, I see! Putting Right() around the range was the one thing I didn't try.

Thanks,

Ken