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

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

--
AJ Maste
-----------------------------------------------------------------------
AJ Master's Profile: http://www.excelforum.com/member.php...fo&userid=1238
View this thread: http://www.excelforum.com/showthread.php?threadid=55383

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

Jim

Thanks.....you were quite right. It should have been (240,1) and no
(1,240). I think the brains had too much VBA today. :)
Thanks...again! ...A

--
AJ Maste
-----------------------------------------------------------------------
AJ Master's Profile: http://www.excelforum.com/member.php...fo&userid=1238
View this thread: http://www.excelforum.com/showthread.php?threadid=55383