Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert rows and concatenate text
Hi All, I'm trying to create macro where i can insert rows and concatenate it with text, but it has to be from cursor position. I think i need to modify the syntax in the module, but i don't know how the syntax should be formed (newbie to macro) Appreciate if you can help me with the syntax, because i have thousands lines need to be inserted :(::::: Thanks in advance for your advices. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert rows and concatenate text
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) |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro to insert rows and concatenate text
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text to Rows and then Insert Blank Rows | Excel Discussion (Misc queries) | |||
Manipulating Text in Rows with COUNTA and CONCATENATE | Excel Programming | |||
how insert the return key in formulas for concatenate of text? | Excel Discussion (Misc queries) | |||
Macro to concatenate multiple rows in a column, without selecting each group manually | Excel Programming | |||
Macro to Insert Rows After a given Text in Col A | Excel Programming |