Hi all,
i have the following code which puts a sequential number in column P, which is fine.
My question is how do i prefix this with the letters VOMH and then have leading 0's (zeros) in the column, ie VOHM0001, VOMH0002 and so on.
Any help appreciated
Private Sub CommandButton2_Click()
If...