hello, please help!!!
briefly,i have to enter data in an excel worksheet,and after that,
have to cope everything and paste it in another program( AS/400 this i
not important) ,and the problem is that the AS/400 needs to hav
specific number of characters in every column, what i want to do , i
to write a function, or a small program in VBA so that i can identif
the number of characters in every column..
1.going to datavalidationtext length ... doesnt work, cause i want i
to erase automatically what is beyond the length needed
2. the function LEFT(A1;10) for example is not working in my exce
2002, i don't know why, maybe if it works it would be great,but i
seems that excel is not recognising it
3.in VBA

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Column < 2 Then Exit Sub
Target = Left(Target, 2)
End Sub
is working,but i when i paste more than one cell in more than one cel
in the column 2 (in this example) it is giving me an error, moreover,
don't know how to write it in order to program many columns at the sam
time...
thanks for hel

--
abouass
-----------------------------------------------------------------------
abouassi's Profile: http://www.excelforum.com/member.php...fo&userid=3759
View this thread: http://www.excelforum.com/showthread.php?threadid=57216