copy a 2 dimensional array to a range
Hello,
What would be the most fastest way to copy a 2 dimensional array (rXc) to a range starting at cell A1? Thanks Avi |
copy a 2 dimensional array to a range
What would be the most fastest way to copy a 2 dimensional
array (rXc) to a range starting at cell A1? Let's say your array's name is ARR. Assuming your array is one-based (not zero-based), then this line of code will do what you asked for... Range("A1").Resize(UBound(Arr, 1), UBound(Arr, 2)) = ARR Rick Rothstein (MVP - Exce) |
copy a 2 dimensional array to a range
On 25 oct, 19:27, "Rick Rothstein"
wrote: What would be the most fastest way to copy a 2 dimensional array (rXc) to a range starting at cell A1? Let's say your array's name is ARR. Assuming your array is one-based (not zero-based), then this line of code will do what you asked for... Range("A1").Resize(UBound(Arr, 1), UBound(Arr, 2)) = ARR Rick Rothstein (MVP - Exce) Many thanks. It works ! Avi |
All times are GMT +1. The time now is 08:49 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com