Need Help With Excel Macros

April 7, 2009 at 14:36:09
Specs: Windows XP
I am trying to create a Macro in Excel. I need it to: Delete row 2
Delete column c
Delete columns o - z
Am I allowed to delete columns in this way? I keep returning a blank page.

The other functions I need are performing properly. I'm wondering if I'm not supposed to delete the columns.


See More: Need Help With Excel Macros

Report •


#1
April 7, 2009 at 15:04:42
re: Am I allowed to delete columns in this way?

In what way? You haven't told us what you are doing, so how could we answer that question?

Sub OneWay()
 Rows(2).EntireRow.Delete
 Range("C:C,O:Z").EntireColumn.Delete
End Sub


Report •

#2
April 7, 2009 at 17:18:07
Sorry, I am new to Macros. I am right clicking on the column to delete. I have since gotten my macro to work, as long as I don't use a macro to delete the columns.
I am not familiar with VBA. Can I delete the columns a different way?

Thank you for your help.


Report •

#3
April 7, 2009 at 19:07:29
You still haven't given us enough information.

I offered code to delete columns, but you haven't told us anything about your macro or what errors you're getting.

There's no way we can help without some details.


Report •

Related Solutions


Ask Question