Compile error in Excel

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
 
C

Casey

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
 

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

Top