top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

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

+1 vote
475 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:
Facebook Share Button Twitter Share Button LinkedIn Share Button
Try something like this

With Sheets(shtname)
        .Columns("D:G").EntireColumn.Delete
End With
Thanx Salil, I got the answer.

...