Hello, I am using [lastColumn = Range("BB1").End(xlToLeft).Column] to find
out where is the last column, it will return an integer. I can not use this
integer in the following: [Columns("A:" & lastColumn).NumberFormat = "@" for
example. I have to hard code the equivalent like [Columns("A:" &
lastColumnStr).NumberFormat ...]. This is not practical if the report is
dropping or adding a column. Is there a way to solve this if I want to use
the following construct: [Columns("A:" & lastColumn).NumberFormat ....]?

Thank you for your input