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

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