How can we delete few columns from Excel if it is having multiple sheets

490 views

My Excel has 50 sheets i want to delete coulmn 4 to 7 from each sheet, how can we do this through visual basic

closed with the note: Comments has solved the issue and no action is required.

posted Apr 3, 2014 by Neeraj Pandey

Looking for an answer? Promote on:

Try something like this

With Sheets(shtname)
.Columns("D:G").EntireColumn.Delete
End With

commented Apr 4, 2014 by Salil Agrawal

Thanx Salil, I got the answer.

commented Apr 5, 2014 by Neeraj Pandey

...

How can we delete few columns from Excel if it is having multiple sheets [CLOSED]