Tom,

What do you get when you run this:

Sub Test()
Msgbox Range("C-ACCOUNTS Total").Value
End Sub

HTH,
Bernie
MS Excel MVP


"Tomski" wrote in message
...

I have tried the above and also a line where I took out the 'value' from
Cells(Range("C-ACCOUNTS
Total").Value), as I was think that this is like an associate array
hence "C-ACCOUNTS Total" would only be needed to reference.

Both throw an error. Any more suggestions as this would save a lot of
time as I am using a loop at the mo, I think unnecessarily.


Cheers,

Tom


--
Tomski
------------------------------------------------------------------------
Tomski's Profile: http://www.excelforum.com/member.php...o&userid=26824
View this thread: http://www.excelforum.com/showthread...hreadid=500720