To be fair, the code provided does exactly what you described ... in three different ways. More as an exercise but also to give you the opportunity to see different ways of doing it ... with the expectation that you may want to adapt it and one way might be easier than another.
The code below will do what you now ask. The setup is a little more complex as it now needs to establish which cell is a) selected and b) to be used as the "base address".
It should cope with you copying your 24 cell single column range anywhere on the sheet. Simply select any cell within the range and run the macro. Note the caveat in the code regarding blank cells.
Regards, TMS
Bookmarks