LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Insert row with formulae without contents

Catastrophe! I did not keep a copy of a macro which inserted a row above and
copied everything from the row below into the new row except any contents and
fill color. The formula in some of the cells was copied but none of the
contents so the new row was ready for entries

One of you helped with this several years ago and it has been very useful €“
please help again.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA - Insert row, copy contents of original row except for contents of columns A-N Royzer Excel Programming 4 February 21st 12 08:04 PM
VBA - Insert row, copy contents of original row except for contents of column A Royzer Excel Programming 4 February 21st 12 02:47 PM
Delete the contents of all cells which dont contain formulae Warby Excel Discussion (Misc queries) 4 January 14th 08 04:16 PM
Macro to Insert a row and copy Formulae Philip J Smith Excel Programming 3 February 2nd 06 03:29 PM
Delete cell contents that contain numbers and not formulae ... Rob Keel[_2_] Excel Programming 3 September 22nd 05 03:18 PM


All times are GMT +1. The time now is 12:46 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"