#1
|
|||
|
|||
VBA - Hide Column
Hey,
I'm trying to create a really easy VBA script for hiding the column from E to H. When I run the code all the Column from A to I are hidden. I don't understand why! Can someone help me? Thanks in forward Code:
Sub Macro3() Columns("E:H").Select Selection.EntireColumn.Hidden = True Range("F3").Select End Sub |
#2
|
|||
|
|||
Do you have merged cells ?
|
#3
|
|||
|
|||
You're right!
Thank's you |
#4
|
||||
|
||||
Hi,
Try this userform that I created to hide-unhide columns : |
#5
|
|||
|
|||
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Invioce: Hide cost in column F | melvin1942 | Excel | 2 | 04-20-2018 07:01 AM |
Hiding column does not hide chart series | HFLO | Excel | 2 | 10-09-2017 12:33 AM |
How to Hide/Un-hide a worksheet based on cell on another sheet. | easton11 | Excel Programming | 1 | 06-02-2015 12:07 PM |
How can I temporarily break a 3 column format in order to type a single column paragraph | William P | Word | 1 | 01-04-2015 06:40 PM |
Hide Row and Column Headers | mhlipp | Excel | 1 | 11-14-2011 05:10 AM |