Thread: unable to retrieve data
View Single Post
 
Old 02-22-2018, 10:32 PM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 64bit
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
NoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really niceNoSparks is just really nice
Default
Afraid I don't really follow what you're trying to do,
but this is the line that wrote the b array to the sheet
Code:
.Range("A4:W" & Rows.Count).Resize(UBound(b, 1), UBound(b, 2)) = b
Reply With Quote