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

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

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