Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
New value in a cell
Hi
I'm using this to write a new value in a empty cell With Worksheets("Ark1") Set cell = .Cells(Rows.Count, 1).End(xlUp) End With If Not IsEmpty(cell) Then Set cell = cell(2) cell.Value = antal this code insert a new postin collum A Now my problem is that i have 2 values i want to ahve in collum A and B How do i do that? regards Alvin |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
New value in a cell
if i understand, you wnt something in the cell next to it?
cell.offset(0,1).value = "your 2nd value" -- Gary "alvin Kuiper" wrote in message ... Hi I'm using this to write a new value in a empty cell With Worksheets("Ark1") Set cell = .Cells(Rows.Count, 1).End(xlUp) End With If Not IsEmpty(cell) Then Set cell = cell(2) cell.Value = antal this code insert a new postin collum A Now my problem is that i have 2 values i want to ahve in collum A and B How do i do that? regards Alvin |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
New value in a cell
Hi
- first , you may want to put a dot '.' in front of the property Rows.Count. - now to get the cell to the right of the variable cell, you can use : cell.Offset(0,1) With Worksheets("Ark1") Set cell = .Cells(.Rows.Count, 1).End(xlUp) End With If Not IsEmpty(cell) Then Set cell = cell(2) cell.Value = antal cell.Offset(0,1).Value = ... -- Regards, Sébastien <http://www.ondemandanalysis.com "alvin Kuiper" wrote: Hi I'm using this to write a new value in a empty cell With Worksheets("Ark1") Set cell = .Cells(Rows.Count, 1).End(xlUp) End With If Not IsEmpty(cell) Then Set cell = cell(2) cell.Value = antal this code insert a new postin collum A Now my problem is that i have 2 values i want to ahve in collum A and B How do i do that? regards Alvin |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
New value in a cell
thanks its working
best regards ALivn "sebastienm" wrote: Hi - first , you may want to put a dot '.' in front of the property Rows.Count. - now to get the cell to the right of the variable cell, you can use : cell.Offset(0,1) With Worksheets("Ark1") Set cell = .Cells(.Rows.Count, 1).End(xlUp) End With If Not IsEmpty(cell) Then Set cell = cell(2) cell.Value = antal cell.Offset(0,1).Value = ... -- Regards, Sébastien <http://www.ondemandanalysis.com "alvin Kuiper" wrote: Hi I'm using this to write a new value in a empty cell With Worksheets("Ark1") Set cell = .Cells(Rows.Count, 1).End(xlUp) End With If Not IsEmpty(cell) Then Set cell = cell(2) cell.Value = antal this code insert a new postin collum A Now my problem is that i have 2 values i want to ahve in collum A and B How do i do that? regards Alvin |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
New value in a cell
Yes thank you
Alvin "Gary Keramidas" wrote: if i understand, you wnt something in the cell next to it? cell.offset(0,1).value = "your 2nd value" -- Gary "alvin Kuiper" wrote in message ... Hi I'm using this to write a new value in a empty cell With Worksheets("Ark1") Set cell = .Cells(Rows.Count, 1).End(xlUp) End With If Not IsEmpty(cell) Then Set cell = cell(2) cell.Value = antal this code insert a new postin collum A Now my problem is that i have 2 values i want to ahve in collum A and B How do i do that? regards Alvin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing Options | Excel Discussion (Misc queries) | |||
Code to copy the formulae of one cell to all the cell in the rangewith the specific cell and columnnumber changing | Excel Discussion (Misc queries) | |||
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4 | Excel Worksheet Functions | |||
How to create/run "cell A equals Cell B put Cell C info in Cell D | Excel Discussion (Misc queries) | |||
data validation to restrict input in cell based on value of cell above that cell | Excel Programming |