View Single Post
 
Old 08-18-2016, 09:14 AM
mcronin mcronin is offline Windows 7 64bit Office 2016
Novice
 
Join Date: May 2016
Posts: 4
mcronin is on a distinguished road
Default Simple Hide columns macro, when I execute it hides everything left of selection, please help

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
Reply With Quote