View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ivan H. Ivan H. is offline
external usenet poster
 
Posts: 1
Default macro written in Excel 2000 not working in Excel 2002

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?