(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 *