Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Active Cell plus number of Rows
Hi Amber,
Try this. ActiveCell.Offset(1, 0).Resize(240, 1).Select HTH Regards, Howard "Amber" wrote in message om... Hi all! I am a novice with xl macros and could use some help. I have data that spans 240 rows in one column. I have done a cell find to access the column I want and I want to select the next 240 rows in that column. I keep getting a compiling error when trying to range and select those 240 the cells. Here's what I have: Cells.Find(What:="power", LookIn:=xlValues, LookAt:= _ xlPart, SearchOrder:=xlByColumns, MatchCase:= _ False).Activate 'these next two rows of programming are the problem ActiveCell.Offset(1,0) Range(ActiveCell, ActiveCell.Offset(240,0)) Can anyone help? Thanks in advance |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamically display in Active Cell value from 2 rows above it | Excel Discussion (Misc queries) | |||
Dynamically display in active cell the value x-rows above it? | Excel Discussion (Misc queries) | |||
How to Add Rows From Active Cell with in a XLL Code | Excel Worksheet Functions | |||
Insert a number of rows based on a value in a cell on active row | Excel Discussion (Misc queries) | |||
Insert a number of rows based on a value in a cell on active row | Excel Worksheet Functions |