Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error in Excel
I have some macros that were working fine. Now, i'm getting a Compile Error that says, "WRONG NUMBER OF ARGUMENTS OR INVALID PROPERTY ASSIGNMENT." It is having a problem with the following code: Columns("H:I").Select Selection.Delete Shift:=xlToLeft This works in my other spreadsheets, but not in this one. Any thoughts? I don't understand what the Compile Error is. Thanks, M -- MBA2004 ------------------------------------------------------------------------ MBA2004's Profile: http://www.excelforum.com/member.php...o&userid=35946 View this thread: http://www.excelforum.com/showthread...hreadid=557353 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Compile error in Excel
Your code works fine for me as written. Two observations. Is the reason you are saying these lines of code are the source of the error, is because they are highlighted when you select debug? Second; it is rarely if ever necessary to select things in order to work with them in VBA. Your code: Columns("H:I").Select Selection.Delete Shift:=xlToLeft Can be reduced to: Columns("H:I").Delete Shift:=xlToLeft and work better. I might suggest that you post your entire code so the experts here can help you. I'm not one of those experts by the way, I'm just trying to help you as far as I can. HTH -- Casey ------------------------------------------------------------------------ Casey's Profile: http://www.excelforum.com/member.php...fo&userid=4545 View this thread: http://www.excelforum.com/showthread...hreadid=557353 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Compile error in Excel 2002 | New Users to Excel | |||
VBAProject name compile error, not defined at compile time | Excel Programming | |||
Compile error when closing excel | Excel Programming | |||
Excel 2002 Compile Error ? | Excel Programming |