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


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.





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



Forgot to post the code:
Sub DeleteColumn()
Selection.Delete Shift:=xlToLeft
End Sub