Thread: 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

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" <alvinKuiper@discussions.microsoft.com> wrote in message
news:4A7A7F2F-6963-455F-BAEC-3DA8A9E5A7BF@microsoft.com...
> 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
>

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" <alvinKuiper@discussions.microsoft.com> wrote in message
> news:4A7A7F2F-6963-455F-BAEC-3DA8A9E5A7BF@microsoft.com...
> > 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
> >
>
>
>