Hi Rick,

Thanks for replying.

I actually wanna insert couple of rows under certain row and fill in the
cell by adding digits in column A and concatenate text in column B. It has to
be able to insert the new rows starting from wherever rows the cursor is
pointing to.

For example:

original row highlight by cursor is Row 10, which Column A has ID XX100, and
Column B has text "original text1", and addtionional text in cell C1
("addition")

I want the macro to insert 4 rows under Row 10, and then populate ID in
Column A by adding (01) -- result would be XX10010. In Column B, after
concatenation between column B and reference cell, it would be "original
text1 - addition".


Thanks a lot for the advice. Really appreciate it.


"Rick Rothstein" wrote:

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)