My macro has worked fine previously and all of a sudden this error
message comes up:

Object Variable or WIth block variable not set

This happens on the last line of this:

Sheets("Menu").Select
Future = Cells(34, 2).Value
If Future = Empty Then GoTo 1
Sheets("Portfolio Valuation").Select
Cells.Find(What:=Future).Select

Basically I am asking the marco to seach for the word Liab, which I
have entered a on a sheet, and it calls this Future as above. Then it
seaches for this word on the sheet Portfolio Valuation.

Please help!!!


--
CarolineHedges
------------------------------------------------------------------------
CarolineHedges's Profile: http://www.excelforum.com/member.php...o&userid=35705
View this thread: http://www.excelforum.com/showthread...hreadid=560184