View Single Post
  #6   Report Post  
Old August 10th 12, 02:02 PM posted to microsoft.public.excel.newusers
Cimjet[_4_] Cimjet[_4_] is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2012
Posts: 29
Default Deleting A COLUMN BY MACRO

On Friday, August 10, 2012 8:54:25 AM UTC-4, Cimjet wrote:
On Sunday, August 5, 2012 5:38:53 PM UTC-4, satish_vemuri @ hotmail. com 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




















--








Hi

Your not replying to Ron

So this will delete columns, you can edit or add to it.

You could record a macro for what you want or we are not getting the question right.

A reply from you would be good

Regards

Cimjet

Forgot to post the code:
Sub DeleteColumn()
Range("A:A,C:C,E:E,H:H").Select
Selection.Delete Shift:=xlToLeft
End Sub