In VB macro how do I select range from active cell

Hey guys and gals, Thanks for lookin at this problemmmmm???

When I am writing a macro using visual basic, how do I select a range which includes 2 rows down and 8 rows across (selects the range not just the single cell) from the currently selected/active cell then copy it: All this starts from the cell the user starts from.
Example......

PuzzeledProgramer

ActiveCell.Range("A1:H2").Select

Andrea Jones
www.allaboutoffice.co.uk
www.allaboutclait.com

"spydor" wrote:

>
> Hey guys and gals, Thanks for lookin at this problemmmmm???
>
> When I am writing a macro using visual basic, how do I select a range
> which includes 2 rows down and 8 rows across (selects the range not
> just the single cell) from the currently selected/active cell then
> copy it: All this starts from the cell the user starts from.
> Example......
>
> PuzzeledProgramer
>
>
> --
> spydor
> ------------------------------------------------------------------------
> spydor's Profile: http://www.excelforum.com/member.php...o&userid=28438
> View this thread: http://www.excelforum.com/showthread...hreadid=496798
>
>

Activecell.Resize(2,8).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"spydor" <[email protected]> wrote in
message news:[email protected]...
>
> Hey guys and gals, Thanks for lookin at this problemmmmm???
>
> When I am writing a macro using visual basic, how do I select a range
> which includes 2 rows down and 8 rows across (selects the range not
> just the single cell) from the currently selected/active cell then
> copy it: All this starts from the cell the user starts from.
> Example......
>
> PuzzeledProgramer
>
>
> --
> spydor
> ------------------------------------------------------------------------
> spydor's Profile:
http://www.excelforum.com/member.php...o&userid=28438
> View this thread: http://www.excelforum.com/showthread...hreadid=496798
>

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
>