Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: Range.

  1. #1
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a macro which makes takes excel to an unspecified that it works out but then I wnat it to go 14 columns to the right on the same row then selct the next 3 cell to the right ie goto O14 (active cell) then select O14 through P145. Any ideas ?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Milwaukee, WI
    Posts
    105
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    "I have a macro which makes takes excel to an unspecified that it works out but then I wnat it to go 14 columns to the right on the same row then selct the next 3 cell to the right ie goto O14 (active cell) then select O14 through P145. Any ideas ?"

    Not sure what you want, but give this a go:

    FirstOne = ActiveCell.Offset(0,14).Address
    LastOne = ActiveCell.Offset(0,16).Address
    Range(FirstOne & ":" & LastOne).Select

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Posts
    133
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Just what the doctor ordered.
    Many thanks.

Some videos you may like

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
  •