Macro That Deletes Columns

  • Thread starter Thread starter Lilbit
  • Start date Start date
L

Lilbit

I tried to record a macro that allows me to delete columns I don't need in
a report that I regularly generate from a program. Some of the columns
are noncontiguous. Everytime I record the macro, choose the columns to be
deleted, and go to Edit, Delete, I get the message, “That command cannot be
used with selections that contain entire row or columns, and also other
cells. Try selecting only entire row, entire columns, or just groups of
cells.” Is there a way around this? Thanks!!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro analyses Cell . If text found , delets entire row 6
Simple Macro 1
Macro for fast deletion of rows that conatin certain data. 2
Macro - Import, Delete, Concatenate 2
Macro delete columns satring row 23 3
Would love to write macro to delete any row that DOESN'T containspecific text.. 6
delete entire row with condition 7
Named cells in an array to a column and to a row 3

Back
Top