Cell R5 contains =A5&" "&B5&" "&C5

When I select cells A5, B5 and C5 then click 'Insert' and "Shift cells down",
the formula in R5 changes to =A6&" "&B6&" "&C6

How can I write the formula in cell R5 so it is always =A5&" "&B5&" "&C5

Try...

=$A5&" "&$B5&" "&$C5

...so the formula becomes column-absolute/row-relative

--
Garry

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