| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Select all Data on Active Sheet
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, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select all Data on Active Sheet
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 "Theresa" wrote: 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, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select all Data on Active Sheet
Range(Range("A4"), ActiveCell.SpecialCells(xlLastCell)).Select Gord Dibben MS Excel MVP On Fri, 25 Jul 2008 13:28:16 -0700, Theresa wrote: 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, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Select all Data on Active Sheet
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? "FSt1" wrote: 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 "Theresa" wrote: 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, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to set printer default to select active sheet not whole book | Excel Discussion (Misc queries) | |||
| Macro with input box to Select a column on active sheet | Excel Programming | |||
| How to select the active sheet? | Excel Worksheet Functions | |||
| select all cells in an active sheet containg links to other (external) workbooks. | Excel Programming | |||
| Select all pivot table areas/ranges on the active sheet problem | Excel Programming | |||
Linear Mode
