assign value to a cell on next column
 

I´m triying to assign a value to next cell (+ 1 column) of active one,
but doesn´t work in this ways:


Cells(ActiveCell.Row, ActiveCell.Column + 1).Value = "888"

ActiveCell.Offset(0, 1).Value = 2222

some help???

thanks

assign value to a cell on next column
 

What happens when you do each of these?



wrote:

I´m triying to assign a value to next cell (+ 1 column) of active one,
but doesn´t work in this ways:

Cells(ActiveCell.Row, ActiveCell.Column + 1).Value = "888"

ActiveCell.Offset(0, 1).Value = 2222

some help???

thanks

--

Dave Peterson

assign value to a cell on next column
 

I would think either one would work unless you are in the last column.

--
Regards,
Tom Ogilvy


" wrote:

I´m triying to assign a value to next cell (+ 1 column) of active one,
but doesn´t work in this ways:


Cells(ActiveCell.Row, ActiveCell.Column + 1).Value = "888"

ActiveCell.Offset(0, 1).Value = 2222

some help???

thanks