Dragging down Formulas
 

Guys and Girls,

Just wondering if it is possible to drag formula's down the page past a merged cell!

Its not letting me do it, as when i drag my formula over the merged cell and keep going, i get an error message saying that the cells are not identically sized???

thanks

Sadly not. Well no way that I can think of...

Dragging down Formulas
 

On Tuesday, June 5, 2012 10:07:54 PM UTC-4, phil2026 wrote:
Guys and Girls,

Just wondering if it is possible to drag formula's down the page past a
merged cell!

Its not letting me do it, as when i drag my formula over the merged cell
and keep going, i get an error message saying that the cells are not
identically sized???

thanks




--
phil2026

No

Dragging down Formulas
 

Just one of the many problems that arise when you use the dreaded
merged cells feature.

No way around it.............other than NOT using merged cells.


Gord

On Wed, 6 Jun 2012 02:07:54 +0000, phil2026
wrote:


Guys and Girls,

Just wondering if it is possible to drag formula's down the page past a
merged cell!

Its not letting me do it, as when i drag my formula over the merged cell
and keep going, i get an error message saying that the cells are not
identically sized???

thanks

Dragging down Formulas
 

hi,

no, but..
horizontal alignment: centered across columns

--
isabelle



Le 2012-06-05 22:07, phil2026 a écrit :
Guys and Girls,

Just wondering if it is possible to drag formula's down the page past a
merged cell!

Its not letting me do it, as when i drag my formula over the merged cell
and keep going, i get an error message saying that the cells are not
identically sized???

thanks

Dragging down Formulas
 

It happens that phil2026 formulated :
Guys and Girls,

Just wondering if it is possible to drag formula's down the page past a
merged cell!

Its not letting me do it, as when i drag my formula over the merged cell
and keep going, i get an error message saying that the cells are not
identically sized???

thanks

You can try selecting all the cells to receive the formula (including
the merged cell if desired), type the formula in the active cell, press
'Enter' while holding down 'Ctrl'. This will populate your formula in
all selected cells regardless of 'size' due to merging!

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion