Urgent!
Could any one tell whether there is a limit on the number of variables in Range(). I have the following codes:
Worksheets("sheet1").Activate
Range(Cells(iShift * 21 - 16, iCol), Cells(iShift * 21 - 5), iCol).ClearContents
But it always pops up a message to tell me
"Compile Error. Wrong Number of arguments or invalid property assignment"
Could you fix this problem for me.
Thanx
regards
Andrew XJ
Could any one tell whether there is a limit on the number of variables in Range(). I have the following codes:
Worksheets("sheet1").Activate
Range(Cells(iShift * 21 - 16, iCol), Cells(iShift * 21 - 5), iCol).ClearContents
But it always pops up a message to tell me
"Compile Error. Wrong Number of arguments or invalid property assignment"
Could you fix this problem for me.
Thanx
regards
Andrew XJ