select range

  • Thread starter Thread starter geebee
  • Start date Start date
G

geebee

hi,

i have the following:
Range("A5000").End(xlUp).Offset(0, 0).Select

the only problem is this is being run when the sheet is in Autofilter mode.
I want the range to be selected, except for the header row. How can i modify
this?

thanks in advance,
geebee
 
I take it that your header row is in row 1 (A1):

Range(Range("A2"), Range("A500").End(xlUp)).Select

Also, you don't need Offset(0, 0). This does nothing unless one of the
values in the parenthesis is less than or greater than 0.

Alan
 

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

Select Case code error 8
Clean this select case code up a bit. 2
Eliminate blanks while copy row and transpose 11
Find string from column A in Range("B2:F7") list the header of that column/s 5
last record 4
Get rid of need for F2.Select 3
Range(sheet2) = Range(sheet1) 11
Post my named ranges in column A 10

Back
Top