Totally hide with VB

mark 27 · Feb 27th, 2002, 02:44 PM

I have a sheet that has an advance filter to transfer onto another sheet, is there anyway that for example I can hide selected columns in the finished sheet in the same macro?

gplhl · Feb 27th, 2002, 02:56 PM

Quote:

On 2002-02-27 13:44, mark 27 wrote:
I have a sheet that has an advance filter to transfer onto another sheet, is there anyway that for example I can hide selected columns in the finished sheet in the same macro?

Use

Columns("A:A").Select
Selection.EntireColumn.Hidden = True

to hide column A or replace the letters to select a range of columns.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 27th, 2002, 02:44 PM	#1
mark 27 New Member Join Date: Feb 2002 Location: Mark Posts: 5	I have a sheet that has an advance filter to transfer onto another sheet, is there anyway that for example I can hide selected columns in the finished sheet in the same macro?