Insert row-doesn't add formulas into hidden columns.

  • Thread starter Thread starter lunker55
  • Start date Start date
L

lunker55

Column D is hidden with formulas.
When I insert a row, the formula is not inserted in the hidden column.
Does anyone have any ideas on how to overcome this?

Joe
 
Hi Joe
formulas are not inserted with newly inserted rows (would also happen
if column D wasn't hidden).
AFAIK this can only be done with macros
 
Depending on how complex your row is, you might try:
<Copy> <InsertCopiedCells>
instead of *just* <Insert>.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================



Column D is hidden with formulas.
When I insert a row, the formula is not inserted in the hidden column.
Does anyone have any ideas on how to overcome this?

Joe
 
Back
Top