Click button to automatically add row

[yirawan]

Does anyone know how to add a button if clicked can automatically add row or column along with formula? By having the button will allow someone to add as many row as possible without being through hassle to copy all formula everytime new row or column is added. thanks much

[Ron de Bruin]

Hi yirawan

See David's site
http://www.mvps.org/dmcritchie/excel/insrtrow.htm


--
Regards Ron de Bruin
http://www.rondebruin.nl


"yirawan" <[email protected]> wrote in message
news:[email protected]...
>
> Does anyone know how to add a button if clicked can automatically add
> row or column along with formula? By having the button will allow
> someone to add as many row as possible without being through hassle to
> copy all formula everytime new row or column is added. thanks much
>
>
> --
> yirawan
> ------------------------------------------------------------------------
> yirawan's Profile: http://www.excelforum.com/member.php...o&userid=29036
> View this thread: http://www.excelforum.com/showthread...hreadid=487969
>