Excel 2010 Columns Select

[ICdeadppl]

Hi, not sure if I'm having a mental breakdown or not, but I am sure this used to work. Instead of selecting the columns between the 2 variables it's selecting the entire sheet.
I've set scol & ecol as Integers

Rows("1:1").Select
Selection.Find(What:="start", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
scol = ActiveCell.Column
Columns(scol).Select 'I thought this would select the activecell column, but it's not ?
Selection.Find(What:="cumulative", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate
ActiveCell.Offset(0, -1).Activate
ecol = ActiveCell.Column
Range(Columns(scol), Columns(ecol)).Select

 

[p45cal]

You have some merged cells? Perhaps merging across an entire row somewhere?

 

[ICdeadppl]

thanks so much