You guys and gals on this site are brilliant and I appreciate the help I've received over the year.
Can you give me the syntax for selecting a range of unknown number of rows and a known number of columns. I would like to use the End(xlDown) code to first select the entire number of rows in a table, but would then like to "pull back" one row so as to exclude the last row. Then I would like to finish by selecting 4 columns to the right using an "Offset" command.
Any help would be appreciated.
Can you give me the syntax for selecting a range of unknown number of rows and a known number of columns. I would like to use the End(xlDown) code to first select the entire number of rows in a table, but would then like to "pull back" one row so as to exclude the last row. Then I would like to finish by selecting 4 columns to the right using an "Offset" command.
Any help would be appreciated.