wibbers2000
08-26-2007, 11:37 PM
I have a problem with the left in a loop.
I can code it into the sheet with =left(j2,5) and that works fine and I can drag the formula down the page. However I am struggling to get it to work via VBA in a loop.
Ideally what I would like is to look at column D and if it is not blank "" then look at column J and take the first 5 digits and put them into column O
Any assistance would be greatly received.
regards
Paul
I can code it into the sheet with =left(j2,5) and that works fine and I can drag the formula down the page. However I am struggling to get it to work via VBA in a loop.
Ideally what I would like is to look at column D and if it is not blank "" then look at column J and take the first 5 digits and put them into column O
Any assistance would be greatly received.
regards
Paul