| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
assign value to a cell on next column
|
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I assign a number to a name in another column? | Excel Worksheet Functions | |||
| How do I assign a number to a name in another column? | Excel Worksheet Functions | |||
| How do assign formulas to an entire column? | Excel Worksheet Functions | |||
| Assign column | Excel Discussion (Misc queries) | |||
| looking to assign different numbers in column B to different words in column A | Excel Worksheet Functions | |||
Linear Mode
