In VB macro how do I select range from active cell

Bob...

Sweeeeet!! This is a nice solution to "ShouldBeSimple" thing to find with the Excel Help menus.

Sure Appreciate the Info.........

Spydor

When in VB Editor check out help on "resize"



Gord Dibben Excel MVP

On Thu, 29 Dec 2005 16:33:47 -0600, spydor
<[email protected]> wrote:

>
>Bob...
>
>Sweeeeet!! This is a nice solution to "ShouldBeSimple" thing to find
>with the Excel Help menus.
>
>Sure Appreciate the Info.........
>
>Spydor

Andrea's solution is very similar, it is just perhaps not so obvious that
Range("A1:H2") refers to 2 rows and 8 columns from the actrivcell, it does
not refer to the actual range A1:H2.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"spydor" <[email protected]> wrote in
message news:[email protected]...
>
> Bob...
>
> Sweeeeet!! This is a nice solution to "ShouldBeSimple" thing to find
> with the Excel Help menus.
>
> Sure Appreciate the Info.........
>
> Spydor
>
>
> --
> spydor
> ------------------------------------------------------------------------
> spydor's Profile:
http://www.excelforum.com/member.php...o&userid=28438
> View this thread: http://www.excelforum.com/showthread...hreadid=496798
>