View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 6,953
Default Copy from various sheets and create a master list.

Dim v as Variant, i as Long, sh as worksheet

--
Regards,
Tom Ogilvy


"J.W. Aldridge" wrote:


Thanx Tom.
However, getting error on the following:

Dim va s Variant, i as Long, sh as worksheet