Dragging down Formulas

P

phil2026

Guys and Girls,

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

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

thank
 
S

Spencer101

phil2026;1602406 said:
Guys and Girls,

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

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

thanks
Click to expand...

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

James Ravenswood

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
Click to expand...

No
 
G

Gord Dibben

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
 
I

isabelle

hi,

no, but..
horizontal alignment: centered across columns

--
isabelle



Le 2012-06-05 22:07, phil2026 a écrit :
 
G

GS

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
Click to expand...

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
 
Top