Runtime error 9 - subscript out of range error

Trying to enter info into worksheets with the worksheet name (membername) being pulled from row A in the reference worksheet (scoresheet). The last line throws a error 9 - subscript out of range error

Please Login or Register  to view this content.

try

Please Login or Register  to view this content.

all range variables must be SET in vba
namedatacell is declared as a range

Edit - you seem to be using a lot of variables and you do not need to.
These alternatives should also do the job

avoid namedatacell with:

Please Login or Register  to view this content.

or go straight there with

Please Login or Register  to view this content.

Thanks kev_, I tried that and then got a Runtime Error 1004 at that line, then I defined the variable i = 1 and it throws the same original error

I declared the range variables with SET here

Please Login or Register  to view this content.

Look at my edits and try the final one - it works for me
-you could also try Activate instead of Select - but it should not make a difference here

Does the worksheet exist?

Go into VBA and click on "View" then "Immediate Window"
An extra window is opened up and you can test things there

immediately below line

Please Login or Register  to view this content.

insert these lines

Please Login or Register  to view this content.

and remove the line where you are selecting the sheet (the line with the error)

You shoulsd always see a pair of values in the immediate window
If the first does not show and the 2nd does for any pair, that worksheet does not exist - (typo?)

Interesting, the first line gave the same error, so I switched the order. The scoresheet.Range().Value gave me 2 2 0 in the immediate window. Is this considered a pair?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

EDIT
I'm trying to reference a worksheet named Members as indicated by this line

Please Login or Register  to view this content.

and a Members worksheet definitely exists

Number 2 at the beginning identifies the debug line
The 2nd 2 is the value of i
The 3rd value is what is in the cell
So you appear to be telling VBA to select sheet named 0 (zero) or possibly Sheet(0) ie the zeroeth sheet - which does not exist

If the line beginning 1 (ie the first debug line) did not print to screen it is because that sheet does not exist and VBA cannot tell you its name

Please Login or Register  to view this content.

should return the name of the sheet called whatever the value in A & i is
- and so VBA should give you the same answer as the other debug line

oh! Okay I'm realizing now that this is saying that i = 2 and the value in cell A2 at this point is 0, when it should be the name...I think the error here is that the i needs to stand for the column and not the row.

How can I use the column number as a variable for the Range object? Range(1,i) is throwing a 1004 error

EDIT

Alright I can use cells to get the output I am looking for and it worked!

The issue was I wasn't referencing the sheet name I was referencing a value in a lookup table.

Uses Cells(row, column) instead of Range(address).