How to Select a Whole Column Using Cells(1,1) Style?

**One-Eyed Enos** · 05-09-2012, 04:39 PM

In the macro below, how would I convert "Columns("B:B").Select" to the "Cells(1,1)" approach so that I can start using variables and delete as many columns as I want? I've tried the obvious substitutions but seem to have the syntax slightly wrong.

Thank you.

Please Login or Register  to view this content.

**Bob Phillips** · 05-09-2012, 04:42 PM

Please Login or Register  to view this content.

**mrice** · 05-09-2012, 04:43 PM

Try

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

**Paul** · 05-09-2012, 04:43 PM

Hi Enos,

Do you mean something like..

Please Login or Register  to view this content.

You could use Cells() references instead, but they work the same.

**One-Eyed Enos** · 05-09-2012, 05:18 PM

Thank you, gentlemen--that solves my problem completely.

How to Select a Whole Column Using Cells(1,1) Style?

LinkBack

Thread Tools

Rate This Thread

Display

How to Select a Whole Column Using Cells(1,1) Style?

Re: How to Select a Whole Column Using Cells(1,1) Style?

Re: How to Select a Whole Column Using Cells(1,1) Style?

Re: How to Select a Whole Column Using Cells(1,1) Style?

Re: How to Select a Whole Column Using Cells(1,1) Style?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions