Thread: Simple Hide columns macro, when I execute it hides everything left of selection, please help
View Single Post
 
Old 08-31-2016, 05:15 PM
p45cal's Avatar
p45cal p45cal is offline Windows 10 Office 2010 32bit
Expert
  
Join Date: Apr 2014
Posts: 956
p45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond reputep45cal has a reputation beyond repute
Default
I suspect there are merged cells.
You might get away with
Code:
Columns("D:K").entirecolumn.hidden=true
Reply With Quote