Hello!

Can some one tell me how to repeat a specific command within a Macro?
My case:
In tab 1 I copy in columns of raw unsorted data
In tab 2 the raw data from tab 1 needs to be grouped and sorted
according to a custom format.

I already defined a macro that copies the raw data and puts it into the
custom format, but as the number of columns differs I was wondering if
there is a statement in VBA that repeats a command depending on the
amount of columns (ranges) that are provided.

Thanx in advance!

Regards,
Robert