Hi,

I want to write a macro by whic I will mention the number of characters in one column then it should select only those number of characters for the entire row.

eg. if I mention number of characters as 6 for 'column a', (I will mention this in a seperate column. Macro should read this value from that column) then it should copy only 6 characters of EACH cell in 'column a'

Do we anything kind of format etc for this thing?

Thanks,
Sylvia