View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] cesgonzalez@aquanima.com is offline
external usenet poster
 
Posts: 3
Default 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