Yes, change

Const WS_RANGE As String = "A1"

to

Const WS_RANGE As String = "B1"

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"mehare" wrote in
message ...

Thanks for the help but I've never used code in Excel.

I've pasted it in, the left hand drop down menu says "worksheet" and
the right hand "change". Is this correct?

The information I want as the name of the sheet is in cell b1. Do I
have to change anything in the code to make this happen?

Thanks again


--
mehare
------------------------------------------------------------------------
mehare's Profile:
http://www.excelforum.com/member.php...o&userid=37483
View this thread: http://www.excelforum.com/showthread...hreadid=571408