Hi,
How can I write values from selected range into an 1D array?
This is my code so far:
The problem is that this code writes into my array only value from the first selected cell. Can you advise how to write all values from filtered range into an array?.Range(XStart & ":" & XEnd).SpecialCells(xlCellTypeVisible).Select Dim XArr As Variant XArr = Selection
Thanks in advance
Regards
Bookmarks