I have a fairly large Excel spreadsheet, there are around 4500 rows with 35 columns.
Our VBA code references columns by their letter (aka A1, A2, A3 ... A4500) when modifying field values ... this is a limitation as we are unable to move columns around within our sheet without having to update all of our code to where that column has moved to.
Is it possible to give a column a variable name?
If column A currently holds First Name, is it possible to name this column First_Name so that regardless of where this column moves, it retains the First_Name reference?
Then in our VBA code we can say First Name instead of A1?
Thanks!