Thanks All
WebTest:
I think I understand this for the most part, but what exactly is 'aRange'

I just tried this and it didn't work:
VB Code:
  1. Range("A7").Cells (Range("A7").Cells.Count)

I looked up aRange is the help files and found nothing