dbmathis
Well-known Member
- Joined
- Sep 22, 2002
- Messages
- 1,064
I have the following lines that don't work
What this is supposed to do is start in cell C52 of sheet "Cash Flow Statements" and search across the sheet in a right direction until the number 1 is found and assign the cell location that the 1 is in to variable c.
The code above just does not work.
Thanks.
Code:
Dim c As Range
Dim rng As Range
Set c = rng.Find(1, After:=Range("C52"), LookAt:=xlWhole, SearchOrder:=xlByColumns, SearchDirection:=xlNext)
What this is supposed to do is start in cell C52 of sheet "Cash Flow Statements" and search across the sheet in a right direction until the number 1 is found and assign the cell location that the 1 is in to variable c.
The code above just does not work.
Thanks.