Run-time error '1004': Application-defined or object-defined error

[WaqasTariq]

Hi guys,

Thank you for all the help provided so far (by just searching relevant info on the forum), the forum is a huge resource of knowledge.

OK, here is what I am trying to do

• The macro finds the number of 'columns' that have data (from column 7 onwards), done.
• The macro then also finds the number of rows that contain data (in column 7, the master column), done
• According to the number of columns I concatenate G1 with G2, G1 with G3, H1 with H2, H1 with H3 and so on (according to the number of columns with data + rows number taken from master column)

I have been able to copy/paste most of the code to successfully work as I want, this is the last line of code that works

Please Login or Register  to view this content.

While when I add another to the same, it gives the "Run-time error '1004': Application-defined or object-defined error" error. I think I have used a lot of code for one cell and maybe that is the reason the code is being generated, any help with this will be appreciated.

Please Login or Register  to view this content.

[Norie]

You've exceeded the 255 arguments limit for CONCATENTATE.

Why not just use the ampersand, &, as the concatenate operator in the code?

Please Login or Register  to view this content.

[WaqasTariq]

You've exceeded the 255 arguments limit for CONCATENTATE.

Why not just use the ampersand, &, as the concatenate operator in the code?

Thank you so very much, I am very much a newbie into macro creation, this worked like a charm. Thanks again!