problem with macro in a repetitive task

**mahmoodn** · 01-03-2011, 02:47 AM

Hi,
Consider I have these numbers in cells:

Please Login or Register  to view this content.

Now I want to attach group 2 and 3 to the right of group 1. So

Please Login or Register  to view this content.

I record a macro first (with relative reference) and places group 2 to the right of group 1. Then I stop the macro recording and select group 3. After running the macro, I saw that group 3 is placed right to the group 2 (and not group 1).

Please Login or Register  to view this content.

Any idea about that?

**JBeaucaire** · 01-03-2011, 04:37 AM

Use your mouse to highlight this column of values, then run this macro:

Please Login or Register  to view this content.

As per your example, it uses the blank cells in between each group to note specific "groups" (called AREAS) and copies them one at a time next to the first "group" in your selection.

**snb** · 01-03-2011, 06:30 AM

Please Login or Register  to view this content.

**mahmoodn** · 01-03-2011, 08:55 AM

JBeaucaire, thanks it works fine.

snb, when I run your code, I get runtime error 1004. Can you please state what is the procedure? maybe I did wrong.