[Solved] Macro Column selection keeps defaulting to "C:x" instead of just "x"

[Cappytano]

I'm new to macro, but most certainly not to excel formulas. I figured due to the logical approach this would be fairly simple with the "record macro" feature, but I'm growing frustrated. Note: this is office 2013.

My goal is this:

Click one of three buttons.

Button 1 must show column F and hide G:I

Button 2 must show column G and hide F, H:I

Button 3 must show columns H:I and hide F:G

Simple enough right?

Everytime I get to the bold step utilizing the "step in" (F8) for visual basic instead of highlighting JUST column F (or any column i try to put in there), it selects C:F instead of just F:

Sub Macro6()
'
' Macro6 Macro
'
'

'
Range("F1").Select
Columns("F").Select
Selection.EntireColumn.Hidden = True
Columns("H:I").Select
Selection.EntireColumn.Hidden = True
Columns("E").Select
Selection.EntireColumn.Hidden = False
End Sub


Note: the above isn't the proper code, i've just been trying to troubleshoot what does what and how. I've narrowed it down to this reality...it keeps selecting C through whatever column. It's driving me mad. I've been working on this spreadsheet for 2 solid work weeks and this is tying me up. Please help

[skywriter]

Please Login or Register  to view this content.

[Cappytano]

Thank you Skywriter

I had to edit the B1, B2,B3 as they will be conflicted name wise but it did function how I needed it with a little tweaking.


I am curious though. Do you know WHY my code was pulling column "C"? I want to understand so I don't repeat my error.

I will mark this post solved after.

[bulina2k]

Hi there and sorry for jumping in unannounced/uninvited..
my guess is that you have somewhere a merged area between C and F columns...
and when you select F column it selects the C:F columns because of the merged cells

[Cappytano]

Hi there and sorry for jumping in unannounced/uninvited..
my guess is that you have somewhere a merged area between C and F columns...
and when you select F column it selects the C:F columns because of the merged cells

Hit the nail on the head. Completely overlooked this.



double-facepalm.jpg