Inputbox compile error

[rtcwlomax]

Hi All,

I have a very basic macro which I want to expand upon however the code is returning a Compile Error: Wrong number of arguments or invalid property assignment.

When I run the Macro in a blank WB its ok however when I run it in the WB I'm working on it returns the error and highlights the 'Range'. Any ideas why this might be happening?

Please Login or Register  to view this content.

[cytop]

...returning a Compile Error

There's nothing there that would cause a Compile Error... and a compile error is not generated when you're running the code, it would occur BEFORE any code actually runs. Perhaps if you uploaded a copy of a workbook that displays the issue?

[rtcwlomax]

Hi, thanks for looking.

I have managed to get it to work by adding more code.

Please Login or Register  to view this content.

[cytop]

So not a compile error, then.

[rtcwlomax]

Excel was saying 'Compile Error' but take your point. Cheers