Macro to Hide a Column with a relative position

**zhavier** · 05-16-2014, 02:04 PM

I am trying to hide a column titled "Test". This column is usually olumn E, but it is possible it can be moved to column D or F. If I use

Please Login or Register  to view this content.

then column E is hidden, regardless of whether Test is moved left or right. The reason Test moves is due to the user inserting or deleting a column.

**JOHN H. DAVIS** · 05-16-2014, 02:24 PM

Maybe:

Please Login or Register  to view this content.

**zhavier** · 05-16-2014, 03:03 PM

That works pretty well, thanks. One thing though, if it doesnt find test, it hides whatever column happens to be selected.

**JOHN H. DAVIS** · 05-16-2014, 03:22 PM

You're welcome. Try.

Please Login or Register  to view this content.

**HaHoBe** · 05-16-2014, 03:27 PM

Hi, zhavier,

Please Login or Register  to view this content.

Using objects is a better way to deal with this.

Ciao,
Holger

**zhavier** · 05-16-2014, 04:38 PM

Thanks a bunch, that works great, HaHoBe

Re: Macro to Hide a Column with a relative position