Substr Copy

[DTHMTL]

Can you copy a substr of text using VBA?

123456ABC7890

I know that I can use this to copy the entire cell
Range("A1").Copy

I want to copy "ABC" and that is it. I tried using "substr" combinations
both they don't seem to work.

Thanks

 

[Tom Ogilvy]

Do you actually need to get it into the clipboard?

If not

Range("B9").Value = Mid(Range("A1").Value,7,3)

if you need a string/text in the clipboard, see Chip Pearson's page on the
DataObject

http://www.cpearson.com/excel/clipboar.htm

 

[DTHMTL]

Sorry I mean "mid", I was thinking VFP

 

[Frank Kabel]

Hi
is the value you want always at the same position?. If yes use Tom's
solution. If not you may provide some more details which substring you
want to get (that is what logic has to be applied)