In VB macro how do I select range from active cell

  • Thread starter Thread starter spydor
  • Start date Start date
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
 
Activecell.Resize(2,8).Select

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
When in VB Editor check out help on "resize"



Gord Dibben Excel MVP
 
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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

macro to select a range from a set cell to a specified cell 6
loop until empty row and column problem (format cells until the lastrow and column in a report) 2
Macro DoSomething in every cell of my selected range 1
Find copy data from a cell in Personal workbook and copy it to a cellin current workbook 14
Moving a bunch of data 1
MACRO RUN random percentage and copy of column values 1
Excel How do I delete images in a specific range 1
Get Name of Sheet to use in Macro 11

Back
Top