Is there any way to use a macro to select a user defined column e.g. column S, together with all the columns to the right of that column and then have the Macro delete the selected columns. A key to this would be that it would need to cycle through every sheet in the workbook excluding the first say two or three sheets, again it needs to be possible to specify which sheets to exclude.

It would be great if the same could be achieved for rows, though I don't know if that would need to be done via a second macro?

Many thanks