How can I use Visual Basic to get the range of the active selection in an Excel spreadsheet? ?

Every search variation I can think of comes up with instructions on how to select a range from Visual Basic. This isn’t what I want to do.

I’m trying to determine the range of the current selection in Excel.

its called selection

alt-11
ctrl-g

type ? selection.address

The above will show you the address of your current select range

One Response to “How can I use Visual Basic to get the range of the active selection in an Excel spreadsheet? ?”

  1. tankahn says:

    its called selection

    alt-11
    ctrl-g

    type ? selection.address

    The above will show you the address of your current select range
    References :

Leave a Reply