I have some code to find a value in a worksheet:
Code:
--------------------
Cells.Find(What:="HTD Total", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False).Activate
--------------------
I need to be able, once found, to offset by 4 rows to the right and
then select the next 12 rows and copy.
basically 4 cells to the right of 'HTD Total' is a row of 12 cells I
need to copy.
what is the syntax for the selecting this range?
thanks in advance,
--
matpj
------------------------------------------------------------------------
matpj's Profile:
http://www.excelforum.com/member.php...o&userid=21076
View this thread:
http://www.excelforum.com/showthread...hreadid=481912