I'm sorry again, but I just can't help thinking this simple task is being made more difficult than it really is.
If you left click and hold on A4
Then drag your mouse down, the Name Box (which Rick cleverly used before) automatically and dynamicly shows you how many rows/columns you have selected.
Just move your mouse down till the Name Box Says 17R X 1C (or 18r?).
Release the mouse, and press CTRL+D
I'm sorry again, but I just can't help thinking this simple task is being made more difficult than it really is.
If you left click and hold on A4
Then drag your mouse down, the Name Box (which Rick cleverly used before) automatically and dynamicly shows you how many rows/columns you have selected.
Just move your mouse down till the Name Box Says 17R X 1C (or 18r?).
Release the mouse, and press CTRL+D
Chalk it up to being forum responders, our minds automatically jump to the 'more clever' solutions, than the simple ones.
Maybe you just wanted to show off that neat trick....j/k