top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

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

+1 vote
54 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 Google+ Share Button LinkedIn Share Button Multiple Social Share Button
Try something like this

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

Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...