| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple Ranges = same value
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Ranges = same value
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Ranges = same value
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Multiple Ranges = same value
Except for the typo <vbg, that looks the easiest to me.
But you could use: ActiveSheet.Range("a3,a9,e42").Value = 5 This worked in xl2003. 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 -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple IF statements looking up multiple ranges. | Excel Worksheet Functions | |||
| Can I create Multiple passwords to edit multiple ranges? | Excel Discussion (Misc queries) | |||
| How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
| multiple pivot ranges | Excel Worksheet Functions | |||
| Multiple Ranges for a Chart | Charts and Charting in Excel | |||
Hybrid Mode
