View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
CAM CAM is offline
external usenet poster
 
Posts: 65
Default Deleting a column using VBA

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