R1C1 selection in VB
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: R1C1 selection in VB

  1. #1
    Board Regular WillR's Avatar
    Join Date
    Feb 2002
    Location
    Soliohull
    Posts
    1,143
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP Barrie Davidson's Avatar
    Join Date
    Feb 2002
    Location
    Winnipeg
    Posts
    2,330
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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"

    Barrie Davidson

    "You're only given a little spark of madness. You mustn't lose it." - Robin Williams

  3. #3
    Guest

    Default

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




User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com