Hello,
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?
https://www.mrexcel.com/forum/excel-...ml#post5360114PHP Code:
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"
Bookmarks