Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|