خرید بک لینک

Vote count: 0

I have a formula That looks for a "Date:" Value in column A# and Pastes a Formula in the adjacent B cell. But i cant figure out how to make the formula dynamic

So if i have a value in A6 and in A8 - i would want the inserted formula to have the same row number T6 and T8. Right now it uses the same row number every time.

Sub Check()
Dim g As Range
Dim i As Long
  

Set g = Range("A8:A48")
   
For Each cell In g
    'test if cell is empty
    If cell.Value = "Date:" Then
        'write to adjacent cell

        cell.Offset(0, 1).Formula = "=TEXT(T8,""mmm-dd-yyyy"")&"" | ""&V8&"" - ""&U8&"" | Dept: ""&W8"
       
    End If
Next
End Sub
asked 3 mins ago

برچسب: نویسنده: استخدام کار تاريخ: دوشنبه 24 اسفند 1394 ساعت: 20:25

صفحه بندی