View Single Post
  #2   Report Post  
Old August 6th 12, 11:35 AM posted to microsoft.public.excel.newusers
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jun 2010
Posts: 1,045
Default Deleting A COLUMN BY MACRO

On Sun, 5 Aug 2012 21:38:53 +0000, m wrote:


HI all,

every month i geenrate reports. from ms-access i export the reports to
excel. i have various colmns which i dont requier. i need to delete them
manually.
the columns are random.
From A - Z columns the data is filled. most of the columns i dont
requier. by using a macro can i deleted these unwanted columns.

how i can do this. my desk is full load of work.i am new to excel to.

can some one please help me in this regards.
i am great ful to all.

Thanks
VEN


Do you want to delete the entire column, or just the contents of the column?
Are the columns to be deleted the same each month, or are they truly random and change each month?
If the latter, how do you know which one's to delete?