Thread: Deleting A COLUMN BY MACRO
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Ron Rosenfeld[_2_] Ron Rosenfeld[_2_] is offline
external usenet poster
  
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?
Reply With QuoteReply With Quote