Tony Singh
12-06-2013, 08:43 AM
Hi
A programme I use requires a minimum of 8 characters to a code, anything less
and the programme will not pick up the entry unless I complete the code by adding
an X to the end to make the total characters up to a maximum of 8.
I have only managed to come up with the following:
Sub Macro1()
Dim C As Range
For Each C In Selection
If C.Value <> "" Then C.Value = C.Value & "XXX"
Next
End Sub
I would appreciate some help.
Thanks
A programme I use requires a minimum of 8 characters to a code, anything less
and the programme will not pick up the entry unless I complete the code by adding
an X to the end to make the total characters up to a maximum of 8.
I have only managed to come up with the following:
Sub Macro1()
Dim C As Range
For Each C In Selection
If C.Value <> "" Then C.Value = C.Value & "XXX"
Next
End Sub
I would appreciate some help.
Thanks