adding values to multiple cells

[Luis939]

is there anyway of adding one value to 2 or more cells, all in the same line

I'd like to say cell A1 and cell A2 = myvalue

is there anyway of doing that, or must i repeat that instruction for each cell

 

[tony813]

Hello 4335,
You have the For Loop option:

For i = 1 To 2 'Indicates the row number
Cells(i, 1).Value = Myvalue
Next i

tony813

Tony813

 

[Luis939]

True, thanks!

 

[Zathras]

If you are adding to the cells (as you say in the subject), then tony813 gave you the answer.

On the other hand if you are initializing the cells (as you indicated in your example) then you can use this to set (not add) all of the cells in a range at once:
[blue]

  Range("A1:A2") = 42

[/color]

 

[Luis939]

oh ok thanks!