Compile error in Excel

  • Thread starter Thread starter MBA2004
  • Start date Start date
M

MBA2004

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
 
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
 
Back
Top