ExcelBanter - Value of a cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Value of a cell (https://www.excelbanter.com/excel-programming/311344-value-cell.html)

Chris

Value of a cell

Hi

how can I get the value of a cells

Me.Cells(Row, 3) = Me.cells.Value(row,1) & Me.cells.value
(row,2)

did not work I have compilation error

What I want is in the column 3 concatinate the value of
column 1 and 2

Any help please

Frank Kabel

Value of a cell

Hi
try:
Me.Cells(Row, 3).value = Me.cells(row,1).value & Me.cells
(row,2).value

--
Regards
Frank Kabel
Frankfurt, Germany

"chris" schrieb im Newsbeitrag
...
Hi

how can I get the value of a cells

Me.Cells(Row, 3) = Me.cells.Value(row,1) & Me.cells.value
(row,2)

did not work I have compilation error

What I want is in the column 3 concatinate the value of
column 1 and 2

Any help please

All times are GMT +1. The time now is 05:06 AM.