Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Is there a better way to delete row 1 in Sheet1 than this
Sheets("Sheet1").Select Rows("1:1").Select Selection.Delete Shift:=xlUp Range("A1").Select Is there a better way to delete Column B in Sheet1 than this? Sheets("Sheet1").Select Columns("B:B").Select Selection.Delete Shift:=xlToLeft Is there a better way using Sheet1, to Cut Column D and paste the cut cells in front of Column A than this? Sheets("Sheet1").Select Columns("D:D").Select Selection.Cut Columns("A:A").Select Selection.Insert Shift:=xlToRight |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Delete rows of data in multiple sheets | Excel Programming | |||
Complex sheets - how can I delete rows without destroying formulas? | Links and Linking in Excel | |||
Delete rows in multiple sheets without loop? | Excel Programming | |||
How can I delete similar rows in excel workbook with many sheets? | Excel Worksheet Functions | |||
Delete Rows from multiple Sheets. | Excel Programming |