R1C1 selection in VB

[WillR]

How do I select a range of cells in VB script
using r1c1 referencing as opposed to absolute.

Need to select a cell & the 7 above it
and then go on to name it as a range in order
to use as the source data for a chart.

Thanks

 

[Barrie Davidson]

On 2002-02-28 03:52, WillR wrote:
How do I select a range of cells in VB script
using r1c1 referencing as opposed to absolute.

Need to select a cell & the 7 above it
and then go on to name it as a range in order
to use as the source data for a chart.

Thanks

Will, assuming the cell you select is C14, this will name the range (C7:C14) Barrie:

Range("C14").Offset(-7, 0).Range("A1:A8").Name = "Barrie"

 

[Guest]

Sorry, but why Range("A1:A8").Name = "Barrie"
Is there?
instead of Range("C14").Offset(-7, 0).Name = "Barrie" ??