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: 2
Default Why is inserting rows throwing off my hidden rows

I have a macro that is using the following code to copy a template row
that is hidden and then it inserts that row below it. The problem is
that all of the hidden rows that are below where I'm inserting are not
changing to account for the added row.

For example.
rows 15, 20 and 25 have templates in them and are hidden
then I will do the following
copy template from row 10
insert template at row 12

Even though all of the data has shifted down 1 row, rows 15, 20 and 25
are still hidden and all of the data that was in those hidden rows are
now showing in rows 16, 21 and 26.

Sheets("Inline").Range("Template").Copy
Sheets("Inline").Range("ResDetEnd").Insert Shift:=xlDown
Application.CutCopyMode = False

Am I forgetting something? Any help would be appreciated.
Thanks,
James

 
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
Macro code to hide rows and not calculate hidden rows bradmcq Excel Discussion (Misc queries) 0 September 1st 09 12:38 AM
Count number of rows, where non relevant rows are hidden Pieter Excel Discussion (Misc queries) 2 November 8th 06 12:24 PM
Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th Excellent1975 Excel Discussion (Misc queries) 0 June 21st 06 08:01 PM
Inserting multiple rows in excel with data in consecutive rows technotronic Excel Programming 2 October 20th 05 03:12 PM
deleting hidden rows so i can print only the rows showing?????? jenn Excel Worksheet Functions 0 October 6th 05 04:05 PM


All times are GMT +1. The time now is 06:17 AM.

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"