New value in a row

[Guest]

Hi

I can only see some answers on how making new value in a collum
like:
Range("a2").End(xlDown).Offset(1, 0) = rew

but how do i make a new value in a row

Regards
Alvin

 

[Norman Jones]

Hi Alvin,

Try:
'=============>>
Public Sub Tester001()
Dim rng As Range

Set rng = Cells(2, Columns.Count). _
End(xlToLeft).Offset(0, 1)
rng.Value = "New"

End Sub
'<<=============

 

[Guest]

yes yes yes

Yhank you

regards alvin

Hi Alvin,

Try:
'=============>>
Public Sub Tester001()
Dim rng As Range

Set rng = Cells(2, Columns.Count). _
End(xlToLeft).Offset(0, 1)
rng.Value = "New"

End Sub
'<<=============