View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Charlie Charlie is offline
external usenet poster
 
Posts: 703
Default is a variant an object

Only when you are setting it to an object, examples:

Dim v As Variant
v = 1.234 'Floating point number
v = "Hello" 'string
Set v = Range("a1") 'object


"James Cornthwaite" wrote:

does when assigning a variant need a set statement?

THanks
James