Комментарии:
Appreciate the tip!
ОтветитьThanks!
Ответитьhi what if I have 3000 columns to resize. Clicking one by one would not be effective. Any thought?
Ответитьah, thanks for the comment, came here looking for exactly that!
ОтветитьSince DataLink arrays are a subset of Excel arrays, any program that resizes Excel arrays should work for DataLink arrays. I searched 'resize excel array vba' and found a few examples out there on the internet. Try those!
ОтветитьHello, is there is an option to resize the array programmatically using VBA?
Ответить