Copying same data range to a summary sheet
Hi Eddie
I am only an intermediate myself and get regular help also, so I can say
with so certainty that to make it easier for everyone to see, it is good
practice to paste in as much of the code as possible so any anomolies can be
seen.
Hmmm, as for Excel running out of columns, more likely the problem maybe a
possible typo in the code as each sheet contains:
256 Columns x 65,536 Rows = 16,777,216 Cells.
Regards
Mick.
|