VBA - Creating Excel Range from VBA Array. With hidden rows.
HTML-код
- Опубликовано: 12 сен 2024
- Welcome back to the channel! 🎉
In our previous video • VBA - Creating an Arra... , we delved into arrays and ranges in VBA, addressing common challenges and solutions. Following up on that discussion, we received a thoughtful question about handling invisible rows due to filtering within an Excel table.
This video actually shows how to target this problem.
Article and code here:
www.vitoshacad...
My GitHub repository for VBA standard functions:
🐙github.com/Vit...
🚀Thanks for watching, and happy coding!
💡#VBA #Excel
🎯#automateexcel #Coding
Thanks for covering this topic. As I see, there is no such fast solution for Array to range as it is for from range to Array....
🙂In general, I am not the ultimate "knowledge tank" of VBA, there could be a few solutions I am not aware of, but in theory you can easily build a `Sub` that gets an array and based of its dimensions it puts it into a range.
Anyway, there are a few decisions you should make - if it is 1D array, how are you going to paste it? (As a column or as a row)
What would you do with 3D arrays? Return error, or just write the first 2 dimensions and forget about the rest?