Thread: Vlookup not working correctly in macro
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
merjet merjet is offline
external usenet poster
  
Posts: 812
Default Vlookup not working correctly in macro
Try using ".FormulaR1C1" instead of ".Value".

Hth,
Merjet


Reply With QuoteReply With Quote