Hi All
I'm looking for some help with a code to select a range based on its headed and footer in Column A
I've got the below code written to find the text 'Bistro' and select the entire top row of the data,
I'm looking to then scroll down to the next instance of the text 'Bistro' in column A so i can then selection.copy
Can it be written into Something like this "Range(Selection, Selection.End(xlDown)).Select" ?
Cells.Find(What:="bistro", After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Offset(0, 5).Activate
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Thanks!!!!!!!
I'm looking for some help with a code to select a range based on its headed and footer in Column A
I've got the below code written to find the text 'Bistro' and select the entire top row of the data,
I'm looking to then scroll down to the next instance of the text 'Bistro' in column A so i can then selection.copy
Can it be written into Something like this "Range(Selection, Selection.End(xlDown)).Select" ?
Cells.Find(What:="bistro", After:=ActiveCell, LookIn:=xlValues, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Offset(0, 5).Activate
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Range(Selection, Selection.End(xlToLeft)).Select
Thanks!!!!!!!