Understood, many thanks.

Regards.

"Harlan Grove" wrote in message
...
"Stuart" wrote...
..
This seems to work until I reach the last 'page' when
suddenly there is no '£' in col(6) to mark the next
'page'......because there isn't a next page, and so
no '£' to Offset back up from!
..

If there's nothing in the cells below the last bit of data, you may want
to move
to the bottom of the worksheet, then use .End to move up to the last row
containing anything, then offset down (and right?) from that cell to enter
a '£'
in col 6, then run your existing procedure, and once it's completed delete
the
added '£' in col 6.

--
1. Don't attach files to postings in this newsgroup.
2. Snip unnecessary text from quoted text. Indiscriminate quoting is
wasteful.
3. Excel 97 & later provides 65,536 rows & 256 columns per worksheet.
There are
no add-ins or patches that increase them. Need more? Use something
else.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/2003