On Dec 3, 10:29*am, Gary''s Student
wrote:
Sub servient()
Range("A3,A9,E42").Value = 5
End Sub

another way is to use Union()

I think that with regard to speed, it does not matter.
--
Gary''s Student - gsnu2007k



"jlclyde" wrote:
I have 3 ranges, that I want to = the same number. *I am doing this
with VBA. *Is there an easier way then
Range("A3") = 5
Range("A9") = 5
Range"E42")=5
??
Thanks,
Jay- Hide quoted text -

- Show quoted text -

Thanks. I was trying Range("A3", "A9", "E42"). this will be much
easier!
Jay