VBA

michissimo · #1 05-25-2021, 11:45 AM

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

NoSparks · #2 05-25-2021, 04:53 PM

Do you have merged cells ?

michissimo · #3 05-26-2021, 12:15 PM

You're right!
Thank's you

john_red · #4 06-11-2021, 12:38 PM

Hi,

Try this userform that I created to hide-unhide columns :

Purfleet · #5 06-11-2021, 01:45 PM

Quote:

Originally Posted by NoSparks

Do you have merged cells ?

Merged cells are evil

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