Column Offset Formula - Sequential Columns Target

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

Hello Folks,

I was trying to populate cells.

I will preface by saying - I still don't understand the offset formula thing
But I managed to get below working

I was trying to put file name in column D, Title in column E, and the content of the file in Column F

Set TargetCell = ActiveSheet.Cells(65536, 4).End(xlUp)
      
    If Len(wText) > 0 Then
      
    Set TargetCell = TargetCell.Offset(1, 0)
      
    TargetCell = wFile.Name               ' COL  D
        
    TargetCell.Offset(, 1) = wTitle      ' COL E
        
    TargetCell.Offset(, 2) = wText       ' COL F
    
    End If

thanks for help and speedy response

sl