View original (French)

VBA; Select Variable Range

Solved
JB22 -  
 JB22 -
Hello,

I have a variable range from A5 to K.. that I want to select, but I can't do it;
I need help,
Thank you
Best regards

4 answers

  1.
    Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Hello,

    the principle

    Range(Range("A5"), Range("K65535").End(xlUp)).Select

    or more technically
    Range([A5], [K65535].End(xlUp)).Select
    --
    Cheers
    Mike-31

    I am responsible for what I say, not for what you understand...
    0
  2. JB22
     
    Thank you Mike-31 for your response.
    Unfortunately, that doesn't work.
    I managed to select the last cell of the range using the following formula, but I couldn't go any further.
    [A65536].End(3).Offset(0, 10).Select]
    Best regards; JB22
    22 =1922, so 99 years, I can be excused!
    0
  3. Mike-31 Posted messages 18405 Registration date   Status Contributor Last intervention   5 147
     
    Re,

    you have already set the status to resolved without having achieved satisfaction, the principle is to find the first non-empty cell by going up one column.
    in your case two possibilities, directly column K with this line of code 
    [K65535].End(xlUp).Select

    or by offsetting the selection closer to your code 
    [A65536].End(xlUp).Offset(0, 10).Select

    then we have a fixed selection point cell A5, just combine the two points 
    Range([A5], [K65535].End(xlUp)).Select


    or starting from column A, offset to column K 
    Range([A5], [A65536].End(xlUp).Offset(0, 10)).Select


    A+
    Mike-31

    I am responsible for what I say, not for what you understand...
    0
  4. JB22
     
    It was by mistake that I put "Resolved"
    But with your last response, the problem is indeed resolved, thank you.
    Best regards, JB22
    0