Thread: Define Object Variable
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jan Karel Pieterse Jan Karel Pieterse is offline
external usenet poster
  
Posts: 535
Default Define Object Variable
Hi Rob,

Are you sure you dont mean:
Set r = ActiveCell


Of course I did, who added that silly .address to it ?

<bg

Regards,

Jan Karel Pieterse
Excel MVP
www.jkp-ads.com

Reply With QuoteReply With Quote