I recorded the following macro that selects all non-blank cells in A:A
Then I used the Shift and Movement Keys to extend the selection till column U.
However, when recording this the range is set to A1:U59 which was the outcome that specific situation. The range however varies, and I'd like to code to do the same.
Please Login or Register to view this content.