Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Columns
Sub DeleteColumns ( )
Range("K:K,M:M,P:P,S:S").Select Selection.Delete Shift:=xlToLeft End Sub Is there a cleaner way to delete these columns than the code above? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Columns
maybe this
Range("K:K,M:M,P:P,S:S").Delete mike "Sal" wrote: Sub DeleteColumns ( ) Range("K:K,M:M,P:P,S:S").Select Selection.Delete Shift:=xlToLeft End Sub Is there a cleaner way to delete these columns than the code above? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete Columns
Exactly what I was looking for. Thank you for the help.
"Mike H" wrote: maybe this Range("K:K,M:M,P:P,S:S").Delete mike "Sal" wrote: Sub DeleteColumns ( ) Range("K:K,M:M,P:P,S:S").Select Selection.Delete Shift:=xlToLeft End Sub Is there a cleaner way to delete these columns than the code above? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create a macro to delete columns and then border remaining columns | Excel Programming | |||
merge text from 2 columns into 1 then delete the old 2 columns | Excel Worksheet Functions | |||
can't delete columns | Excel Programming | |||
Delete columns | Excel Programming | |||
Delete Columns | Excel Programming |