PDA

View Full Version : Put text in multiple cells



josephir
08-08-2014, 11:32 AM
I am trying to put the text "2013" in multiple cells, but when I select a range it only puts the text in the first cell. Is there a concise way to do it for all the cells I want.


Range("C6", "F6", "G5"...etc).Value = "2013" is what I am trying to do now.

mancubus
08-08-2014, 11:40 AM
you're so close. :)


Range("C4,F4,E10,F16").Value = 2013

josephir
08-08-2014, 11:44 AM
Ahhh, thank you so much. Huge help.

mancubus
08-08-2014, 01:26 PM
you're welcome.

please mark the thread as solved from Thread Tools.