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

Thread: easy one

  1. #1
    New Member
    Join Date
    Apr 2002
    Posts
    38
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    this formula is part of a larger formula:

    Range("D5:D" & x).Select

    How can i replace the "5" to, x/2 add 1 using Visual Basic language

  2. #2
    Board Regular eliW's Avatar
    Join Date
    Mar 2002
    Posts
    1,919
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-02 04:43, MERKY wrote:
    this formula is part of a larger formula:

    Range("D5:D" & x).Select

    How can i replace the "5" to, x/2 add 1 using Visual Basic language
    If I understand your question:

    x = 5
    y = Int(x / 2) + 1
    Range("D" & y, "D" & x).Select

    Eli

  3. #3
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-05-02 04:43, MERKY wrote:
    this formula is part of a larger formula:

    Range("D5:D" & x).Select

    How can i replace the "5" to, x/2 add 1 using Visual Basic language
    If I undertand you correctly ?? then
    Range("D" & (x2)+1 & ":D" & x).Select


    Kind Regards,
    Ivan F Moala From the City of Sails

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
  •