macros with functions

[Robert]

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.

 

[OssieMac]

I don't understand enough of your question to fully answer it but if you
record a macro while entering a VLOOK function then it should put you on the
right track.

 

[Ron Rosenfeld]

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.

Application.worksheetfunction.vlookup(args....)
--ron

 

[Don Guillett]

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