(Solved) – Strip away empty columns on the left side of a named range

(solved)-–-strip-away-empty-columns-on-the-left-side-of-a-named-range

Let’s suppose that rangeData refers to a range of cells in a spreadsheet.

If the right most column is empty, I can strip it away by doing this:

rangeData = rangeData.CurrentRegion

But what if the left most column of rangeData is empty?

How do I strip away that column and have rangeData refer to only the columns with values?

Leave a Reply

Your email address will not be published. Required fields are marked *