Whats the macro code to select all cells except row 1????

with activesheet
.rows("2:" & .rows.count).select
end with

is one way.

Meltad wrote:

Whats the macro code to select all cells except row 1????

--

Dave Peterson

One way.
Maybe this:

Range("A2:IV65536").Select


Paul

"Meltad" wrote in message
...
Whats the macro code to select all cells except row 1????

Range("A2",Cells(Range("A2").End(xlDown).Row,Range ("A2").End(xlToRight).Column).Select

HTH
--
Charles Chickering

"A good example is twice the value of good advice."


"Meltad" wrote:

Whats the macro code to select all cells except row 1????

You have already got so many options. Why not one more?

Sheet1.Cells.Resize(Sheet1.Rows.Count-1).Offset(1).Select


"Meltad" wrote:

Whats the macro code to select all cells except row 1????

THANKS ALL!!!


"Dave Peterson" wrote:

with activesheet
.rows("2:" & .rows.count).select
end with

is one way.

Meltad wrote:

Whats the macro code to select all cells except row 1????

--

Dave Peterson