Label multiple columns macro

Hi there -
I would like to create a simple macro that allows me to assigns names to a range of consecutive columns (i.e) the names would be in Row 1 for each column. While I still would have to spell out the names somewhere (such as flower, stone, brick - they are not numbered in any way), is there a relatively condensed way to achieve this?
Thanks!!

Hi, Try:-

Please Login or Register  to view this content.

Regards Mick

Hi Mick -
thanks for your help. That code only labels the first column ...?

Hi, The code should have a "1" add as below , as the array starts at "0".
That aside if you copy the code and run it it should fill columns "A to E".
It certainly worked when I copied back from the thread. !!!

Please Login or Register  to view this content.

Regards Mick