There are only 256 columns (unless you are beta testing the new XL). You are
offsetting by 256 columns, which means there is a good possibility that you
are offsetting right off the end of the sheet, which would generate that
error.
--
HTH...

Jim Thomlinson


"AJ Master" wrote:


I need to clear the contents of a certain range and yes I could just
write the code as follows: Range("a1:b240").clearcontents

however, the range selection depends on the active cell. I have tried
entering the following: Range(activecell,
activecell.offset(1,240)).clearcontents
But I keep receiving a runtime error '1004'. Any ideas on how to fix
this? Thanks....AJ


--
AJ Master
------------------------------------------------------------------------
AJ Master's Profile: http://www.excelforum.com/member.php...o&userid=12386
View this thread: http://www.excelforum.com/showthread...hreadid=553838