Thread: Excel changing date format after VB has run
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Richhall[_2_] Richhall[_2_] is offline
external usenet poster
  
Posts: 41
Default Excel changing date format after VB has run
Seems it was something to do with the VLOOKUP, dates are fine now as I
added:

Set VerRange = Worksheets("Sheet 2").Range("VersionRange")

Everything seemed to start working ok.

Thanks anyway. Eventually I just added the VLOOKUP into the cell
using an Admin sheet with the VerValue set in a cell there.

Cheers

Rich
Reply With QuoteReply With Quote