Hi,
I'm hoping to get some help with a spreadsheet I'm working on. I want to declare an array of 10 different column headings. The cells I want the column headings to start populating are merged cells 4 across (a12:D12). After one heading is entered into this cell range I then want the next one entered in (A13:D13) and this sequence to continue for 5 of the ten headings. I then want the 6th heading to be placed 3 merged cell ranges down and to start again. So If the code started at a12:d12 five headings would finish at a17:d17, then the 6th jump to a20:20 and the tenth finish at a25:d25.
Would any one be able to help me with this?
Regards,
Antm79
I'm hoping to get some help with a spreadsheet I'm working on. I want to declare an array of 10 different column headings. The cells I want the column headings to start populating are merged cells 4 across (a12:D12). After one heading is entered into this cell range I then want the next one entered in (A13:D13) and this sequence to continue for 5 of the ten headings. I then want the 6th heading to be placed 3 merged cell ranges down and to start again. So If the code started at a12:d12 five headings would finish at a17:d17, then the 6th jump to a20:20 and the tenth finish at a25:d25.
Would any one be able to help me with this?
Regards,
Antm79