Simple Hide columns macro, when I execute it hides everything left of selection, please help

mcronin · #1 08-18-2016, 09:14 AM

Hi,

I am creating the simplest macro in the world just to hide specific columns, I used macro recorder for speed and when that didn't work I went to the code to make sure it was ok and it looks fine, see below, I can't understand why it continually hides columns A:C when that is clearly not in the code. I also tried doing the hide code for individual column and that didn't work either. Please help and thanks in advance.

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

NoSparks · #2 08-18-2016, 02:06 PM

Code:

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

will not hide columns A:C.
Care to show us the rest of your code?

p45cal · #3 08-31-2016, 05:15 PM

I suspect there are merged cells.
You might get away with

Code:

Columns("D:K").entirecolumn.hidden=true

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
VBA Code to Hide columns based on selection on prior sheet	Silver1379	Excel Programming	0	04-15-2015 08:40 AM
Hide/Unhide Text Based on Drop Down Selection	gw1500se	Word	3	02-19-2015 12:17 PM
Show/Hide Text based on Checkbox Selection	tammytran105	Word VBA	7	10-02-2014 04:30 PM
Hide/Unhide a Block of Text Based on Choice Selection	inquirer	Word VBA	7	09-22-2014 04:41 PM
How do I call/execute an Excel macro from Access 2003	KramerJ	Excel	2	05-11-2009 11:33 AM