Thread: clear object
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Steve[_42_] Steve[_42_] is offline
external usenet poster
 
Posts: 9
Default clear object

Much obliged.
Thankyou


"Robin Hammond" wrote in message
...
Have you tried

set orders = nothing
set orders = new objName

Robin Hammond
www.enhanceddatasystems.com

"Steve" wrote in message
...
Hi, I have created an object "Orders" with twenty properties.

Is there any instruction I can use to clear all the properties of the

object
without having to go
Orders.OrderID=""
Orders.AttemptID=""
etc.

Thanks