Select all Data on Active Sheet

  • Thread starter Thread starter Theresa
  • Start date Start date
T

Theresa

Hi:

I need to create part of a macro to start at cell A4 on the active sheet and
then select all data on the sheet. The number of columns will remain the
same but the number of rows will constantly change.

Thanks,
 
hi
this will select all data from A4 to last row and over to column h provided
that column a is a solid block of data.
Range(Range("A4"), Range("A4").End(xlDown).Offset(0, 7)).Select

regards
FSt1
 
Range(Range("A4"), ActiveCell.SpecialCells(xlLastCell)).Select


Gord Dibben MS Excel MVP
 
Hi:

That's the problem.....It may or may not be a solid block. There could be
blank cells in the mix.......how do code a CTRL + SHIFT + END function?
 
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

Run macro from active workbook whose name keeps changing 20
Macro to Compile Data from Different Sheets 2
ActiveCell on inactive sheet 8
clear all sheets code 4
Macro to Combine Data from Multiple Sheets with Cell References 4
select a specific ActiveCell by VBA 3
Selective selecting of multiple tabs 7
VBA comparing sheets and cells 1

Back
Top