Macro to Delete columns in different sheets within a workbook

[makku]

Hi,

I would like to delete specific columns in 'sheet 1' and another set of columns in 'sheet 2', 'sheet 3' etc...

Example:

In 'sheet 1', i would like to deleted columns: B, D, F, G, H, P
In 'sheet 2', i would like to deleted columns: B, E, M, P, R, T
In 'sheet 3', i would like to deleted columns: B, C, S, U, X

Please note that i'm working on Excel 2010.


regards,

[Thalassa]

Try

Please Login or Register  to view this content.

[makku]

Thanks.

Is it possible to re-write the code so that a range of columns can be deleted. What i mean is, instead of "F1,G1,H1" is it possible to write as "F1..H1"?

[Thalassa]

Yes, like this

Please Login or Register  to view this content.

[usnaxc]

How would you modify this to make it apply to all sheets regardless of how many there are? for example delete columns L, M, N, Q, R, T... from all sheets in the workbook.

[Thalassa]

Try

Please Login or Register  to view this content.