Hi all,

I need to know how to:

record a macro that will do this action:

1. select a cell with words,
2.Ctrl+ -- to go to the last connected cell with word,
3.move -- again to reach an empty cell,
4.insert a new column.

I tried recording it in this manner, but when i insert a row in, it
goes according to the specific column like H:H

How should i do it?

thanks a lot.