| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
rows().value
My code has these 3 lines to swap rows.
Rows(120).Value = Rows(z).Value Rows(z).Value = Rows(x).Value Rows(x).Value = Rows(120).Value Is this the only way to do it? Also, the formulas are destroyed when using this, and I need to retain them. Thanx ahead, Greg Carter |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| colating multi rows of data into single rows - no to pivot tables! | Excel Worksheet Functions | |||
| Auto extract data & inserts rows additional rows automatically | Excel Discussion (Misc queries) | |||
| Enabling option „Format rows“ to hide/unhide rows using VBA-code? | Excel Discussion (Misc queries) | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Excel 2003 -Rows hidden. Scrolling unhides rows ! How do I stop th | Excel Discussion (Misc queries) | |||
Threaded Mode
