New value in a row
 

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

New value in a row
 

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

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