VBA copy right/left/mid of cell contents

[teatimecrumpet]

Hi,

I know there is a formula to do this. But is it possible to copy the, say right five charcaters of a string in a cell and then pasting that into another cell/sheet/workbook all in VBA?

Just wondering if avoiding a cell formula to grab content is possible.

thanks,
Mike

 

[Desu Nota from Columbus]

Dim LResult As String
LResult = Right("Alphabet",3)
Range("A10") = LResult

This should work.

This would return "bet" in A10

Change alphabet to your cell (and change Right to whatever function suits your fancy)!

 

[Andrew Poulsom]

Like this?

Range("B1").Value = Left(Range("A1").Value, 5)

 

[Desu Nota from Columbus]

Just another thought, the website techonthenet.com is fantastic for self-help.

Nothing tops this forum, but just for quick questions that you can solve individually check it out.

For example, your answer is at the bottom of this page:

http://www.techonthenet.com/excel/formulas/right.php

 

[Desu Nota from Columbus]

Andrew,

Is there a list of functions that VBA performs? I didn't know it had built-in LEFT,Right,MID capabilities.

Is there a list of functions it recognizes (compared to excel functions)?

 

[teatimecrumpet]

Thanks Guys,

Both sets work well.

Desu I've bookmarked that website onto my bar. thanks for that!

I was stuck in the whole "everything should be copy and pasted".

thanks Again

 

[Andrew Poulsom]

There's an alphabetical list of functions in Help under Microsoft Visual Basic Documentation|Visual Basic Language Reference|Functions. Or you can see them under the VBA <globals> Class in the Object Browser.

 

[Desu Nota from Columbus]

There's an alphabetical list of functions in Help under Microsoft Visual Basic Documentation|Visual Basic Language Reference|Functions. Or you can see them under the VBA <globals> Class in the Object Browser.

Thank you.
</globals>