Selección de un Rango Variable con VBA

27 May

Para marcar un Rango varible con programación VBA podemos utilizar esta instrucción:
Range(Selection.End(xlDown), Selection.End(xltoRight)).Select

De esta manera nos aseguramos de que abarque todo el rango hacia abajo y a la derecha sin importar la cantidad de celdas.
Es importante destacar que no deben existir celdas vacías para no alterar la lógica de la selección.


7 comentarios

Publicado por en 27 mayo, 2010 en Rango Dinámico, VBA


Etiquetas: , , ,

7 Respuestas a “Selección de un Rango Variable con VBA

  1. christian louboutin black pumps

    15 mayo, 2013 at 8:37 AM

    My brother suggested I might like this website.
    He was totally right. This post truly made my day. You cann’t imagine simply how much time I had spent for this information! Thanks!

    • jcgonzalez3165

      15 mayo, 2013 at 4:42 PM

      Thank you my friend. It’s a plasure serve you. What ever you need, don’t doubt to ask me. Thank you again.

  2. random

    10 abril, 2013 at 1:58 AM

    Using your company name, I just need to have a discussion with
    their experts where you can sign up with, bid on jobs and find customers.

    The companies that left behind in the competition.
    Zen Cart’s simple admin interface takes some of the techniques which the professionals use in increasing ranking are article submission, directory submission and social book marking. Educate your team on how different local search optimization is from generic content writing and copywriting services. Copy down the keyword to help you with your search engine optimization. Include your primary keyword in your next submissions.

    • jcgonzalez3165

      10 abril, 2013 at 6:41 PM

      Thank you for your suggestions. Currently I do not have a teamñ work, I do it all myself. The main idea is to help with what little I know or I could get from other sites, or what I have learned through the book of Mr. John Walkenbach ( that I acquired some years ago and I’ve been a great help in my knowledge.

  3. christian louboutin

    9 abril, 2013 at 10:14 PM

    I rarely drop comments, but i did some searching and wound up here Selección de un Rango Variable con
    a few questions for you if it’s allright. Is it just me or does it give the impression like some of the remarks come across like written by brain dead visitors? 😛 And, if you are posting on other social sites, I would like to follow anything fresh you have to post. Would you list of the complete urls of your communal sites like your Facebook page, twitter feed, or linkedin profile?

    • jcgonzalez3165

      10 abril, 2013 at 6:38 PM

      Hi Christian. Thank you for visit my page. Actualy I don’t write in others sites, nor even in this because I was taken some seminars. Soon I hope to upload more material.



Introduce tus datos o haz clic en un icono para iniciar sesión:

Logo de

Estás comentando usando tu cuenta de Cerrar sesión / Cambiar )

Imagen de Twitter

Estás comentando usando tu cuenta de Twitter. Cerrar sesión / Cambiar )

Foto de Facebook

Estás comentando usando tu cuenta de Facebook. Cerrar sesión / Cambiar )

Google+ photo

Estás comentando usando tu cuenta de Google+. Cerrar sesión / Cambiar )

Conectando a %s

A %d blogueros les gusta esto: