DELETE COLUMN

verluc · Apr 19th, 2002, 08:56 AM

I have a sheet with the following macroline:

With Sheets("XXX").Columns(1)
.Delete
End With

This means that column A is deleted.
What if I want also to delete column C

Is it possible in the same macroline?
Thanks

Amds · Apr 19th, 2002, 09:05 AM

Quote:

On 2002-04-19 07:56, verluc wrote:
I have a sheet with the following macroline:

With Sheets("XXX").Columns(1)
.Delete
End With

This means that column A is deleted.
What if I want also to delete column C

Is it possible in the same macroline?
Thanks

Sheets("XXX").Range("A:A, C:C").Delete

verluc · Apr 19th, 2002, 09:10 AM

Quote:

On 2002-04-19 08:05, Amds wrote:

Quote:

On 2002-04-19 07:56, verluc wrote:
I have a sheet with the following macroline:

With Sheets("XXX").Columns(1)
.Delete
End With

This means that column A is deleted.
What if I want also to delete column C

Is it possible in the same macroline?
Thanks

Sheets("XXX").Range("A:A, C:C").Delete

Thanks for your solution.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 19th, 2002, 08:56 AM	#1
verluc Board Regular Join Date: Mar 2002 Posts: 1,288	I have a sheet with the following macroline: With Sheets("XXX").Columns(1) .Delete End With This means that column A is deleted. What if I want also to delete column C Is it possible in the same macroline? Thanks