I don't open workbooks.

But you can use offset with negative values to go up or to the left.

activesheet.range("b1").offset(-1,-1)
describes A1.

So once you find that key cell, you can use the offset to get the value and
another offset to plop it in:

If nextTrx.Value Like "FUND*" Then
nexttrx.offset(-1,0).value = nexttrx.offset(3,2).value

(-1,0) means up one row, in the same column.



"keith2816 <" wrote:

HI Dave,

What I need is actually 'go up and not go down' which mean I want the
fund name to be inserted on every page .

U might want to see attached excel to see what i meant...

pls help...

Attachment filename: q&a.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=608901
---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson