Hi There, How do I get the following cell functions in to VBA code? =LEFT(A5,3) =RIGHT(A5,1) many thanks Jon
Forum Rules