macro written in Excel 2000 not working in Excel 2002

I

Ivan H.

I have a macro that I wrote in Excel 2000 and when I try
to run it in Excel 2002, it brings up the debugger. The
message is:

'Compile error:

Wrong number of arguments or invalid property assignment'

What is highlighted is a call to Value(row, col),
specifically in Sheet1.Range(range).Value(row, col).

Any idea what's going on?
 

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

Similar Threads

Need Help with a VBA subroutine 0
export excel data to access table using ADO 0
Throwing #Value in a UDF written in Excel VBA 4
Code works but goes into endless loop and crashes 1
Compare two different workbook sheet to show the difference in text 0
Macro for comparing columns and highlighting matching/differences 13
Converting URLs in comments to Markdown-formatted links 2
Excel 2003/vbx macro errors. 3

Top