I have a problem setting a Vlookup formula with VBA.
When I run the Macro a fileDialog appears asking me for the location of the file several times but that happens just when I use (File as the workbook)
This is my formula
Public File As a Workbook
Dim NBF As Range
Set File =...