Hi There,

How do I get the following cell functions in to VBA code?

=LEFT(A5,3)
=RIGHT(A5,1)

many thanks
Jon