I have an excel like this:
but I want to get all data inside an array without first rows (left to right):
How to get Excel data in order - without first row
Are you saying that you want A1,B1,C1,C2,C3? And not A1,B1,C1,A2,B2,C2,A3,B3,C3? If you want something different, please give us a list.
One simple way is to check each cell's Value property and if it equals "" ( an empty string), then don't add it to the array.
Ed
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
How to post your code.
I would create a Range from the selected cells, and then iterate the range to add cells to an array. If you select the cells with your mouse, as you did in the picture, you can right click and select "Define Name". This creates a named range. You can also create a Range object in code.
Ed
Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
How to post your code.
