Thread: Range Select with ActiveCell and Offset property
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
AJ Master[_9_] AJ Master[_9_] is offline
external usenet poster
  
Posts: 1
Default Range Select with ActiveCell and Offset property

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

Reply With QuoteReply With Quote