| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| select range next to activecell | Excel Programming | |||
| error: ActiveCell.Offset(0, -1).Select = Application-defined or object-defined error | Excel Programming | |||
| Select Activecell in Range | Excel Programming | |||
| offset property to define range | Excel Programming | |||
![AJ Master[_9_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
