Formular in multiple work sheets

  • Thread starter Thread starter BRANDON99
  • Start date Start date
B

BRANDON99

Hi Julie

Your methode seems to work the best, but is there a way of referencin
all the sheets and cell from 1st to last work shet, the only way I ca
see is to add each work sheet individually

Thanks


Stephe
 
Hi Brandon,

unfortunately, not that i know, as it's designed to deal with different
sized ranges, however, once you selected the first range & press ADD the
range outline stays selected, so if they are the samed sized area then it's
just a matter of clicking on the sheet tab & clicking on the Add button ...
rather tedious, i know.

i'm not sure if there's is a VBA solution - somebody else in this forum
might have an idea.

Cheers
JulieD
 
Back
Top