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