Selecting columns in VBA isn't working correctly

[CaptainGravyBum]

Hello,
I'm hoping this isn't a stupid question, but it's confusing the pants off me.
I recorded a macro to select certain columns and delete them, pretty simple right? should be fine.

Sub Macro1()
Columns("B:B").Select
Selection.Delete Shift:=xlToLeft
Columns("E:E").Select
Selection.Delete Shift:=xlToLeft
End Sub

Works ok if I do it myself, but if I run the macro it either selects the entire table or multiple columns. The only thing I can think is that there are some merged cells in the sheet which are overriding which columns are selected.
Does my theory sound correct and how can I get around the problem?

Thanks,

 

[CaptainGravyBum]

I think that I've solved my own problem here, I had overcomplicated things so I simply selected all columns and removed the merge cells before deleting the columns.
Columns("A:F").Select
Selection.UnMerge
Easy really.

 

[RoryA]

Yes, it's the merged cells but you don't have to select anything there:

Sub Macro1()
Columns("B:B").Delete Shift:=xlToLeft
Columns("E:E").Delete Shift:=xlToLeft
End Sub