In VB macro how do I select range from active cell

S

spydor

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
 
B

Bob Phillips

Activecell.Resize(2,8).Select

--

HTH

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

spydor

Bob...

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

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

Spydor
 
B

Bob Phillips

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)
 
Top