I've made some progress. I can get my x, y, z values into an array. My plan is to then drop this array into another array when it's detected that their are no more points to add into the current profile. I'm using a counter to increment to the next array index in my point array pt. The idea here is to increase the array size by one in order to add in another point coordinate. Before I go into my For loop, I initialize count = 0.
When count = 0, my first point data gets inserted into pt fine. When the loop runs through the next time count = 1 and I get an error stating that the subscript is out of range.
I've attached my Excel file with the included data. The Profiles sheet shows the points that each profile should contain. My macro is reading off the values from Sheet1. The Restructure sheet is just extra stuff for me.
Bookmarks