Instead, I would recommend using FIND. Look in the vba help index.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Robert" wrote in message
...
I am using excel 2000. I have created a macro that will clear my "Invoice"
and post pertinent information to the first row of an "Invoice Log" that I
have created in the same workbook, but on another tab. I would like to
have
the macro do a "VLOOKUP"? or some other function to post the next invoice
number into the invoice sheet and post the pertinent data to the
appropriate
invoice# line on the Log sheet when I activate the macro and clear the
invoice sheet. I hope this makes sense. I don't know how to incorporate
an
excel function like "LOOKUP" into a macro.
--
excelguy