New value in a row
yes yes yes
Yhank you
regards alvin
"Norman Jones" wrote:
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
'<<=============
---
Regards,
Norman
"alvin Kuiper" wrote in message
...
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
|