| Home |
| Search |
| Today's Posts |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Why is inserting rows throwing off my hidden rows
It just occurred to me that if you are actually copying and pasting
less than an entire row you can shift cells to the right instead of down: Shift:=xlShiftToRight This will leave other rows unaffected, and your code should work with just the one modification. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro code to hide rows and not calculate hidden rows | Excel Discussion (Misc queries) | |||
| Count number of rows, where non relevant rows are hidden | Excel Discussion (Misc queries) | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
| Inserting multiple rows in excel with data in consecutive rows | Excel Programming | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Threaded Mode
