Thread: Cell values to an array, then array transpose to another workbook
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
  
Posts: 852
Default Cell values to an array, then array transpose to another workbook
I dimmed rngC as Variant and i as Long.
Code is in standard module.

Type mismatch on vaRicho, yellowed out and hover cursor over it.

varRicho(i) = rngC.Value

Howard
Reply With QuoteReply With Quote