Hi All,
I'm trying to find the correct vba syntax to select a row starting from the active cell (variable) out to a named column. The named column location will vary because additional columns will be inserted between it and the active cell.
Example: select active cell A5 (variable) out to my named column (in this case, column G). the resulting selection would be from A5 to G5.
I've tried every combination I can think of, too many to list, plus searched the web, all to no avail. Any suggestions?
I'm trying to find the correct vba syntax to select a row starting from the active cell (variable) out to a named column. The named column location will vary because additional columns will be inserted between it and the active cell.
Example: select active cell A5 (variable) out to my named column (in this case, column G). the resulting selection would be from A5 to G5.
I've tried every combination I can think of, too many to list, plus searched the web, all to no avail. Any suggestions?