Array instead of loop I'm sure
On Wednesday, April 1, 2015 at 10:42:06 AM UTC-7, Claus Busch wrote:
Hi Howard,
Am Wed, 1 Apr 2015 10:04:31 -0700 (PDT) schrieb L. Howard:
To be clear, if the code was to be run on another sheet with a different "map" of the solar panels, I would need to adjust the column ranges to match where the "two row" blocks occur. Correct?
try the following code. It looks for the merged cells and the columns
and you have not to hardcode the range:
Hi Claus,
That is the just great. I don't know what could be better than this.
Thanks for all your effort.
Howard
|