ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VB + Vlookup (https://www.excelbanter.com/excel-discussion-misc-queries/151526-vbulletin-vlookup.html)

pgarcia

VB + Vlookup
 
Should this work?

Privet Sub inputtest()
'
' Macro recorded 2/8/2007 by autpbg1
'
Application.VLookup(Range("B4"),Sheets("Input").Ra nge("A2:M1000"),Sheets("Raw Data"),3,FALSE)
End Sub

Also, how can I loop this to send when there is no date or false?


All times are GMT +1. The time now is 05:40 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com