selecting rows

[Nathalie]

How do i select a whole page, minus the first couple of rows? Or a whole column minus a couple of cells? Is there a way to achieve this without code? Thanks in advance.

[Brian from Maui]

Nathalie,

Yes there is, what are you trying to do with the selected rows and columns

[Nathalie]

I have a master database that i have to transform into 3 subsets. The templates for the three subsets are already set up, so i filter the data of master and place in particular subset. Except master has many more columns (want to delete columns without affecting heading!). And when i place info into subset, should erase everything written previously ( want to delete page minus rows used for headings)!! If you could shed some light, thanks Brian.

[Brian from Maui]

Nathalie,

I think you need a macro to do this. Just hang on, someone will come to the rescue!

[Nathalie]

I am tryin to use a macro, (first time) but i am getting all kinds of errors related to copying and autofilter. I have not been using VBA because not to formiliar with language and don't really have the time to learn syntax. Is there any hope?


[ This Message was edited by: Nathalie on 2002-05-24 10:28 ]

[Arviragus]

On 2002-05-24 08:09, Nathalie wrote:
How do i select a whole page, minus the first couple of rows? Or a whole column minus a couple of cells? Is there a way to achieve this without code? Thanks in advance.

Select A3
Go to Edit>GoTo>Special and type IV65536 in the Reference box
Press Shift+Enter

Similarly for a single column.

[ This Message was edited by: Arviragus on 2002-05-24 14:40 ]

[Arviragus]

If you want to do it with macros :-

To select all cells except the first two rows :-

Sub SelectWholeSheet_Nearly()
[A3:IV65536].Select
End sub


To select all but the first two cells in a particular column, select a cell(or cells) in the column and then run :-

Sub SelectWholeColumn_Nearly()
range(Cells(3,ActiveCell.Column),Cells(65536,Activecell.column)).Select
End sub