Thank you - so simple!
--
Michelle
"PC" wrote:
Select the rows from 32 to the end of the worksheet (row 65k) and then
delete them all
Then save, close and re-open the worksheet.
The alternative is to use a dynamic named range for the word merge.
HTH
PC
"Michelle" wrote in message
...
I am using a worksheet that has been used previously and I have deleted
previous data and started anew. My data finishes on row 31, but when I
CTRL
+ END, it goes to row 60 (seems like it is remembering that it had data in
those rows previously). This is causing problems when I merge with Word.
How can I clear these rows? Have tried deleting them, and Edit, Clear
All.
Any help appreciated.
--
Michelle
|