|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Code:
Columns("D:K").Select Selection.EntireColumn.Hidden = True Care to show us the rest of your code? |
#3
|
||||
|
||||
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 |