Thread: VB Lookup Syntax
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ken Hudson Ken Hudson is offline
external usenet poster
  
Posts: 186
Default VB Lookup Syntax
Hi,
Need help with the correct syntax for Vlookup in VB.

ActiveSheet.Name =
Application.WorksheetFunction.VLookup(D1,[ThisWorkbook.Name]ThisWorkbook.Sheets(2).Name!A1:D300,3,False)

isn't correct.

Reply With QuoteReply With Quote