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!!!
Bookmarks