I have a column of cells named/labelled in series thus: _17548, _17549 and
so on.

I have a cell on another sheet whose value will be, depending on whatever
conditions, one of these values.

I need to paste the value of the correspondingly named cell on the first
sheet to another cell on the second.

I am having major difficulty doing this, I try to assign the value of the
source cell as a variable and then paste the contents of the cell with that
name to the target cell, but it just won't accept the "name" of the cell as a
range type variable. It will accept it as a string, but i can't seem to get
it to accept a string variable in a line such as :-
range("variable_name").select

HELP
I hope i've made this clear for you all,
is there a way around this?
Thanks in advance
John Foster