I have a range that has a couple of filters.
Set rng = .Range(.Cells(startrowsort, 1), .Cells(lastemptyrowsort, 15))
TempArray() = rng
However I wanted that array to contain only VISIBLE data. Right now it includes everything data(visible and not visible). Is there a quick way to get only visible data to an array without LOOPING ?
Set rng = .Range(.Cells(startrowsort, 1), .Cells(lastemptyrowsort, 15))
TempArray() = rng
However I wanted that array to contain only VISIBLE data. Right now it includes everything data(visible and not visible). Is there a quick way to get only visible data to an array without LOOPING ?