Copy a value to a range of cells

Terence · Oct 1, 2003

Hi,

In my VBA program, I would like to put the value of a
variable to a range of cells. e.g. put the same value
from cells A1 to A10. How to do it? I tried to use Range
selection method but it doesn't work.
Anyone knows? Thanks a lot.

Terence

Ron de Bruin · Oct 1, 2003

Try this Terence

Sub test()
Yourstring = "Terence"
Range("a1:a10").Value = Yourstring
End Sub

Terence · Oct 2, 2003

Thanks a lot!

-----Original Message-----
Try this Terence

Sub test()
Yourstring = "Terence"
Range("a1:a10").Value = Yourstring
End Sub

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)

.