Hi folks,

needing some help on offset formula.

I am targeting 3 Columns

Column D,E and F

D and E works, but Column F always appears in Column G

    Set TargetCell = ActiveSheet.Cells(65536, 4).End(xlUp)
      
      If Len(wText) > 0 Then
      
        Set TargetCell = TargetCell.Offset(1, 0)   
        
       ' Starts in D2

        TargetCell = wFile.Name
        Set TargetCell = TargetCell.Offset(, 1)
        
        'Starts in E2
        TargetCell = wTitle
        Set TargetCell = TargetCell.Offset(, 2)
     
       
        How do i get F2?     this goes into column G

        TargetCell.Value = wText
I thought this would be easy - but im not sure what I am doing any more

thanks

sl