Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Need Help With Excel Macros
Name: GH25 Date: April 7, 2009 at 14:36:09 Pacific OS: Windows XP Subcategory: Microsoft Office
Comment:
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.
Name: DerbyDad03 Date: April 7, 2009 at 15:04:42 Pacific
Reply:
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
0
Response Number 2
Name: GH25 Date: April 7, 2009 at 17:18:07 Pacific
Reply:
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.
0
Response Number 3
Name: DerbyDad03 Date: April 7, 2009 at 19:07:29 Pacific
Reply:
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.
Summary: Using Excel 2003 - I do not have any experience writing macros. Tried it on my own and now have a pop-up window everytime I open the excel file, even though I did not write the macro yet. 2 questions ...
Summary: I have an Excel spreadsheet that I need help with a macro. I don't know much about VB scripting but I'm sure there must be a way to do what I want. Here is a link to an Angelfire site I created with...
Summary: Hi all, I need help with an excel macro problem. I am creating what I thought was a simple scheduling macro. Basically I need to take batch residence times (a positive whole number) from cells in shee...
0 
