parth007
Member
I have one excel sheet which have data in Column "A"
Now need Vba code to only write last 3 letters of column "a" in column"B"
Below is the code
Problem here is that column "A" may have n number of records in it... and the code only works for one single column..
any suggestion..
Attached is sample file.
Now need Vba code to only write last 3 letters of column "a" in column"B"
Below is the code
Code:
ActiveSheet.Range("B2:B5000") = Right(ActiveSheet.Range("A2"), 3)
Problem here is that column "A" may have n number of records in it... and the code only works for one single column..
any suggestion..
Attached is sample file.