lpking2005
Board Regular
- Joined
- Mar 21, 2011
- Messages
- 140
Hi everyone,
Im currently having trouble trying to select a cell based on a found rownumber and a string found in a range.
My code basically searches the range("I5:M5") to find the day name and then searches the "Lines" column to find the line number eg. 604.
Then i need it to select the cell that intersects.
Im currently playing around with this bit of code.
You should be able to get an idea from this picture.
Any help is much appreciated!
Thanks.
Im currently having trouble trying to select a cell based on a found rownumber and a string found in a range.
My code basically searches the range("I5:M5") to find the day name and then searches the "Lines" column to find the line number eg. 604.
Then i need it to select the cell that intersects.
Im currently playing around with this bit of code.
Code:
Set FindDay = ThisWorkbook.ActiveSheet.Range("I5:M5").Find(What:=curDayName, LookIn:=xlValues)
Set FindLine = ThisWorkbook.ActiveSheet.Range("B:B").Find(What:=cLine, LookIn:=xlValues)
FindDay.Select
ThisWorkbook.ActiveSheet.Range(FindLine, FindDay).Select
You should be able to get an idea from this picture.
Any help is much appreciated!
Thanks.