Thanks for input PeteB........
tried yr suggestion with code:-
- Code: Select all
Private Sub worksheet_Change(ByVal Target As Range)
If Target.Columns <= 16 Then
Debug.Print " process BA inputs"
'so do code for data changes in this area - BA inputs
End If
If Target.Columns > 20 Then
Debug.Print "do selection process "
'so do code for data changes in this area- selection process
End If
End Sub
Got some odd results - BUT - consistently odd
If i entered a numeric in say A10 , then the anticipated "process BA inputs" was obtained
If i entered a character at A10 , then i got "do selection process "
And it was the opposite outcomes if from inserting numerics/characters in say cell Z10
Alas , it was not consistent , when i dropped the string "a1b1c1" into A10 then A10. It gave the same outcome
Target.Columns takes the 'value' of whatever is entered into the cell
So, to test :-
- Code: Select all
If Target.Columns > 20 Then
is testing the contents of the cell, not where the cell is located
my vb unfortunately is based on 1970's Basic, this 'joined' up VBA is a trial .......