Hi all,
I'm new to the forum and returning to Excel for the first time in approx 15 years. Very rusty w/ basic knowledge.
I currently have a spreadsheet similar to the very simple example attached. I have VBA code as below that forces text in certain ranges to uppercase.
However, I would like to have dynamic named ranges so that the code updates when rows/columns are inserted/deleted on the worksheet.
As this spreadsheet is essentially a template, the ranges will begin with all blank cells and even when filled in will still have some blank cells. I currently have the following two formulas that return the correct first and last cells of a range BUT how do I put them together to specify the range itself? If I try to put a colon between them I get an error.
See spreadsheet for more explanation.
Please ask if any more clarification is needed.
Thank you in advance.
Bookmarks