Range or Column .Select?

**piggypablo** · 03-14-2014, 10:00 AM

I'm trying to select all the cells in column A except for A1 which is a header. I've tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

but get a debug error when trying either one of those.

**JOHN H. DAVIS** · 03-14-2014, 10:06 AM

Maybe:

Please Login or Register  to view this content.

**judgeh59** · 03-14-2014, 10:06 AM

try this

Please Login or Register  to view this content.

**judgeh59** · 03-14-2014, 10:08 AM

@ John - We must have hit the Enter key about the same time --

**Izandol** · 03-14-2014, 10:08 AM

If you truly wish to select all cells apart from A1:

Please Login or Register  to view this content.

**piggypablo** · 03-14-2014, 10:26 AM

Thanks! Tried out both of those and each one worked.

**JOHN H. DAVIS** · 03-14-2014, 10:28 AM

@ judgeh59 - Ha, I noticed that to.

**judgeh59** · 03-14-2014, 10:32 AM

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

Range or Column .Select?

LinkBack

Thread Tools

Rate This Thread

Display

Range or Column .Select?

Re: Range or Column .Select?

Re: Range or Column .Select?

Re: Range or Column .Select?

Re: Range or Column .Select?

Re: Range or Column .Select?

Re: Range or Column .Select?

Re: Range or Column .Select?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA: Select Range of Cells in one Column, Merge, and then proceed to Next Column

Look up cell, use as reference to select from a range, to then select data in a column...

[SOLVED] Select Range Without Specifying Column or Row

Select a range within a column

Select only one column/row in a range

Bookmarks

Bookmarks

Posting Permissions