Thread: under
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Laurent M Laurent M is offline
external usenet poster
 
Posts: 15
Default under

I let Adresse be variant and it works

thanks

"Bob Phillips" wrote:

"Jim Cone" wrote in message
...
Laurent,

With range objects, they must be declared..."Dim"


Not so, if not declared as a specific variable type, they will assume
Variant/Empty, and when set to a specific range, will assume Variant/Range.