(Solved) – How to strip away empty columns on the left side of a named range in excel using a VBA function


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 *