I want to make a macro to find a certain column heading in my spreadsheet that says "Outlet #" and then have select all of the non blank cells below it. There seems to be something wrong with my code. Can anyone please help?
Code:
ActiveSheet.Range(Cells.find(What:="Outlet #", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False),
(Cells.find(What:="Outlet #", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).End(x1Down)).Select