View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ExcelMonkey[_93_] ExcelMonkey[_93_] is offline
external usenet poster
 
Posts: 1
Default Application Defined or object defined error

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