I'm trying to create macro where i can insert rows and concatenate
it with text, but it has to be from cursor position.

Can you provide more detail on this so we will have an idea of exactly what
you are trying to accomplish? If you can give us a couple of examples of
before and after, that would help a lot.

--
Rick (MVP - Excel)