Dragging down Formulas

[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

 

[Spencer101]

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

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

 

[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

No

 

[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

 

[isabelle]

hi,

no, but..
horizontal alignment: centered across columns

--
isabelle



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

 

[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

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

 

[phil2026]

Might be an idea to post a dummy example workbook for us to have a loo
at.

[image
http://i1150.photobucket.com/albums/o605/philippe2026/Excelcoding.jpg]

hope this help

 

[phil2026]

[image
http://i1150.photobucket.com/albums/o605/philippe2026/Excelcoding.jpg]

hope this helps

Can anyone help