Lovely people,

I'm having trouble using VBA to move activecell.

For example, i'm using a search macro to find a keyword on m
worksheet, and then i want it to:

Activecell to go down 4 rows, and right 1 column. (ie. from A41 to B4
(but can't use cells as they will change))
Select an area 24 rows down, and 2 columns across (ie. B45:C69) an
copy it onto the clip board.

I think i could do the rest now..

Any help would be very appreciated, thank you

--
druce
-----------------------------------------------------------------------
drucey's Profile: http://www.excelforum.com/member.php...fo&userid=3255
View this thread: http://www.excelforum.com/showthread.php?threadid=53449