Thread
:
Active Cell plus number of Rows
View Single Post
#
2
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Active Cell plus number of Rows
Better than mine but even less will work
Sub makerange()
Cells.Find("power").Select
ActiveCell.Resize(240, 1).Select
End Sub
--
Don Guillett
SalesAid Software
Granite Shoals, TX
"L. Howard Kittle" wrote in message
et...
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 With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]