LinkBack URL
About LinkBacks
I'm trying to select all the cells in column A except for A1 which is a header. I've triedand
Range("A2:A").Selectbut get a debug error when trying either one of those.Columns("A2:A").Select
I'm trying to select all the cells in column A except for A1 which is a header. I've triedandRange("A2:A").Selectbut get a debug error when trying either one of those.Columns("A2:A").Select
Maybe:
Sub piggypablo() Range("A2:A" & Range("A" & Rows.count).End(3)(1).Row).Select End Sub
try this
Range("A2:A" & Cells(Rows.Count, 1).End(xlUp).Row).Select
Ernest
Please consider adding a * if I helped
Nothing drives me crazy - I'm always close enough to walk....
@ John - We must have hit the Enter key about the same time --
@ judgeh59 - Ha, I noticed that to.
If you truly wish to select all cells apart from A1:
Range("A2:A" & rows.count).Select
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
Thanks! Tried out both of those and each one worked.
glad we could help....since you are new to the forum, by the way, welcome, please set the Post to SOLVED if everything worked for you....have a great day
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks