Prev: To attach file to a workbook in a addin.
Next: Z order problems
From: Isis on 4 May 2010 05:12
I have 2 named cells say, tStart and tEnd - If I wanted to set the
contents of all cells within the Range("tStart:tEnd") I thought I could
do something like the following;

Sheet4.Range("tStart:tEnd").Value = "Temp"

but that givs me a '400' type error - what would the way be to reference
these cells.

On a side issue, is it possible to get cell references from a named
cell/Range in some way ?

Thanks for any illumination


Regards
From: Bob Phillips on 4 May 2010 05:32
Try

With Sheet4

.Range(.Range("tStart"),.Range("tEnd")).Value = "Temp"
End With

--

HTH

Bob

"Isis" <isissoft(a)NOSPAMbtinternet.com> wrote in message
news:Xns9D6E67E80F163isissoft(a)193.202.122.122...
>I have 2 named cells say, tStart and tEnd - If I wanted to set the
> contents of all cells within the Range("tStart:tEnd") I thought I could
> do something like the following;
>
> Sheet4.Range("tStart:tEnd").Value = "Temp"
>
> but that givs me a '400' type error - what would the way be to reference
> these cells.
>
> On a side issue, is it possible to get cell references from a named
> cell/Range in some way ?
>
> Thanks for any illumination
>
>
> Regards


From: Luke M on 4 May 2010 11:09
Use a comma so seperate the names, not a colon.

Sheet4.Range("tStart","tEnd").Value = "Temp"

--
Best Regards,

Luke M
"Isis" <isissoft(a)NOSPAMbtinternet.com> wrote in message
news:Xns9D6E67E80F163isissoft(a)193.202.122.122...
>I have 2 named cells say, tStart and tEnd - If I wanted to set the
> contents of all cells within the Range("tStart:tEnd") I thought I could
> do something like the following;
>
> Sheet4.Range("tStart:tEnd").Value = "Temp"
>
> but that givs me a '400' type error - what would the way be to reference
> these cells.
>
> On a side issue, is it possible to get cell references from a named
> cell/Range in some way ?
>
> Thanks for any illumination
>
>
> Regards


From: FSt1 on 4 May 2010 13:11
hi
on the side issue, something like this might work
MsgBox Range("tStart:tEnd").Address
or for a range
MsgBox Range("myRange").Address

regards
FSt1

"Isis" wrote:

> I have 2 named cells say, tStart and tEnd - If I wanted to set the
> contents of all cells within the Range("tStart:tEnd") I thought I could
> do something like the following;
>
> Sheet4.Range("tStart:tEnd").Value = "Temp"
>
> but that givs me a '400' type error - what would the way be to reference
> these cells.
>
> On a side issue, is it possible to get cell references from a named
> cell/Range in some way ?
>
> Thanks for any illumination
>
>
> Regards
> .
>
 | 
Pages: 1
Prev: To attach file to a workbook in a addin.
Next: Z order problems