Hi John,

How have you named the cell?


---
Regards,
Norman



"john foster" <johnfoster@discussions.microsoft.com> wrote in message
news:0EED2C6E-490C-4E05-91C2-F99C8E193243@microsoft.com...
> thanks norman, but method range of object failed @ this line :-
> Rng = Range("_17548")
> plus I want Rng to contain a cell value (cell a1 - which will be one of
> the
> other cell names - say _17548, or 17549 etc, depending on conditions)
>
> sorry
>
> "Norman Jones" wrote:
>
>> Hi John,
>>
>> Try:
>>
>> Dim Rng As Range
>>
>> Rng = Range( "_17548")
>>
>> Sheets("Sheet2").Range("A1").Value = Rng.Value
>>
>> Note that if you use a range variable, an expression like:
>>
>> > range("variable_name").
>>
>> will cause an error: the variable, e.g. Rng, refers to a range, so the
>> use
>> of :
>>
>> > range
>>
>> is incorrect.
>>
>>
>> ---
>> Regards,
>> Norman
>>
>>
>> "john foster" <johnfoster@discussions.microsoft.com> wrote in message
>> news:58C17503-7738-450E-8258-FD242D8925DE@microsoft.com...
>> >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
>>
>>
>>