Thread: Select all but header row???
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Charles Chickering Charles Chickering is offline
external usenet poster
  
Posts: 272
Default Select all but header row???
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????
Reply With QuoteReply With Quote