Deleting a column using VBA

CAM

Guest

Posts: n/a

4th Dec 2008

Hello,

I have a excel 2007 workbook (open) that has some command buttons. I have a
folder call "Budget" which contains about 20 workbooks. All I want to do
is delete column "A" only, in all the workbooks (sheet1) within the folder.
The workbooks will be close if possible. I want to use a command button -
How do I code to delete just column "A" in all the workbooks within a
folder? Any tips or website to visit I will appreicate. Thank you in
advance.

Cheers

« Left() Need the equivalent of this | Inserting three rows at the top »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Hiding a column vs. Deleting a Column	pellechi1@yahoo.com	Microsoft Excel Programming	1	21st Dec 2008 06:46 PM
Deleting cells in a column ref a different column	Daminc	Microsoft Excel Programming	8	23rd Dec 2005 05:04 PM
Re: Delete data only (all) from one column without deleting column itself	Jeff	Microsoft Access	0	20th Sep 2003 03:27 AM
Re: Delete data only (all) from one column without deleting column itself	John Vinson	Microsoft Access	0	18th Sep 2003 05:51 PM
Re: Delete data only (all) from one column without deleting column itself	Mike Painter	Microsoft Access	1	18th Sep 2003 05:32 PM