Hi again,
I've been fiddling with this as i've just noticed that i didn't explain
properly that the contents of the Input box need to be added to the
contents of cell A57 that are already there.
From your answer of:
Worksheets(Range("C4").Value).Range("A57").Value = NumberOfItems
I have tried adding ...Value = range("A57") + NumberOfItems and various
combinations of A57 + NumberOfItems but i just can't seem to find the
correct phrasing for it.
This works perfectly except for this one small detail.
It would also be helpful if you could just explain how the code you've
already given works as i can't see how it applies the worksheet name to
the word 'range' or 'value'.
Sorry if this all sounds stupid, i'm still trying to get to grips with
VB!
Thanks again.
--
h0l1yw0od
------------------------------------------------------------------------
h0l1yw0od's Profile:
http://www.excelforum.com/member.php...o&userid=28989
View this thread:
http://www.excelforum.com/showthread...hreadid=487193