I got the cell.find method off a webpage, I imagine if you google it
you will get the page i got it from... but I don't remember where it
was... there were several methods for determining the last row  on the
page.

I don't really understand what you mean by the uppercase, actually,
I'm not sure why you would do that at all, can you tell me about it?
I mean, BIGSUPPLIER is not really the name I'm looking for, I had to
substitute everything because it is sensitive information. And we
would consider all BigSupplier = BIGSUPPLIER = bigsupplier =
bIgSuPpLier, regardless of case, if you get my drift, but in the
spreadsheet and in the code the cases match.

I completely forgot the Select Case construction existed... doh -_-
I'd rather leave it as it is than change  it, but yea, if I still can't
get it to work i might try that.