View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Brad Yundt Brad Yundt is offline
external usenet poster
 
Posts: 2
Default Algorithm based on time and date ( =Now() )

You're limited to 15 digits with a floating point number,
so you will probably be wanting to construct a string
with your unique ID.

Dim UniqueID As String
UniqueID="Q1234567" & Format(Date,"yyyymmdd") & Format
(Time,"hhmmss")