lynnsong986
Board Regular
- Joined
- May 24, 2014
- Messages
- 146
I need to link a cell on one worksheet to a cell on another. the last line has syntax errors in it and I don't know how to fix it.
the code finds "what" in worksheet 218500Amort. range C12:C500. I need worksheets("218500").range("b22") to have a formula rather than directly = ra. can someone please help?
the code finds "what" in worksheet 218500Amort. range C12:C500. I need worksheets("218500").range("b22") to have a formula rather than directly = ra. can someone please help?
PHP:
Dim ra As Range
Dim what
what = Format(Worksheets("218500").Range("L1"), "m/d/yyyy")
Set ra = Worksheets("218500Amort.").Range("C12:C500").Find(what:=what, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Offset(0, 7)
Worksheets("218500").Range("B22").Formula = "='218500Amort.'!& ra.Address"