Reorganize cells

[Esturgeon]

Hi everybody!!

I am begining to create macros with excel (version 2003), and I really like this forum for all the help it brings me!!

But here I have a problem for which I didn't find any solution yet, concerning reorganization of cells in an excel sheet. To sum up, I created a macro that is able to reorganize a 2*5 table (E4:F8) into a row (H4:Q4), but I would like to apply this macro to any 2*5 table that I select (not only E4:F8, but also E9:F13 for example...) because I have a sheet with hundreds of these 2*5 tables...

Here is the script of my macro, how can I adapt it so that it works on cells I select manually and not only on the E4:F8 cells?

Please Login or Register  to view this content.

I join an excel file as an example.


Thanks for your help,
Olivier.

[protonLeah]

Look here:

[rwgrietveld]

If it is just the 5x2 you select then

Please Login or Register  to view this content.

[Esturgeon]

Both of your solution works very well!!
It will really help me!

Thanks a lot!