Insert Value into cell automatically when new rows are created/inserted

  • Thread starter Thread starter magmike
  • Start date Start date
M

magmike

The value in all cells in column D is as follows:

=IF($D6="","",RIGHT($D6,6))

However, if I insert a row anywhere, I have to copy to formula from
above or below. Is there any coding I can do below to ensure that
anytime a row is inserted that the formula is copied into the new D
Column cell?

Thanks in advance for your help,

magmike
 
magmike pretended :
The value in all cells in column D is as follows:

=IF($D6="","",RIGHT($D6,6))

However, if I insert a row anywhere, I have to copy to formula from
above or below. Is there any coding I can do below to ensure that
anytime a row is inserted that the formula is copied into the new D
Column cell?

Thanks in advance for your help,

magmike
Click to expand...

You could put a 'template' row containing all formulas/formatting at
the top and use a macro to insert it where you want. This would be
considered a "program row" and so could be hidden...

--
Garry

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