Hi;

i'm trying to capture a value in a range. I have the following codeattched
to the click action on a button in my "Results" sheet:

Dim LastDataRow As Integer

LastDataRow = Worksheets("Data").Range("E1").Value

When the above line is reached, I get a "Run time error '9' Subscript out of
range" error message.

Cell E1 of the worksheet labelled "Data" has the value 9 in it. I tried
displaying the value of it by the line :

MsgBox Worksheets("Data").Range("E1").Value

which was placed just before the problem line. When the MsgBox line
executed, the value was blank in the message box.

I'm at a loss as to what the problem is. Any help is greatly appreciated.

--
JJFJR