I have a macro which is failing on line three of this code:
Sheets("Sheet1").Select
Range("C2").Select
ActiveCell.Offset(BlockRow - 3, Seed - 1) = BlockSize
It Selects the Sheet and the cell but cannot execute the last line.
Blocksize is a variable which is defined as:
?Blocksize
0
The error message is:
Run time Error 1004
Application Defined or object defined error.
What am I doing wrong?
Thank
--
Message posted from
http://www.ExcelForum.com