ExcelBanter - viewing specific columns

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - viewing specific columns (https://www.excelbanter.com/excel-programming/392832-viewing-specific-columns.html)

ezil

viewing specific columns

I have data in some 20 columns. But I have to view some 8 or 9 specified
columns
only. For example I have to view column a,n,o and P. How to do this through
macro?

Dave Peterson

viewing specific columns

Maybe you can record a macro when you hide all the columns you don't want to
see.

And record a macro when you unhide all the columns.

Then you can run either whenever you need.

ezil wrote:

I have data in some 20 columns. But I have to view some 8 or 9 specified
columns
only. For example I have to view column a,n,o and P. How to do this through
macro?

--

Dave Peterson

ssGuru

viewing specific columns

On Jul 6, 11:50 am, ezil wrote:
I have data in some 20 columns. But I have to view some 8 or 9 specified
columns
only. For example I have to view column a,n,o and P. How to do this through
macro?

Hide columns or create a Macro that hides columns and runs off a
toolbar button.
Dennis

All times are GMT +1. The time now is 11:59 PM.