Using AND statement to select two cells

[Guzzlr]

Hello All,
I have the following code. I want to have the word Total in D7 & J16.
I dont like this code because it seems redundant.
How do i use something like an AND statement to select D7 AND J16 to input the word "Total" without having multiple lines?
Thanks for the help
excel 2010

[INDENT]Range("D7").Select    
ActiveCell.FormulaR1C1 = "Total"
Range("J16").Select
ActiveCell.FormulaR1C1 = "Total"[/INDENT]

 

[JoeMo]

Range("D7,J16").value = "Total"

 

[Guzzlr]

Range("D7,J16").value = "Total"

Thank you...

 

[Rick Rothstein]

Range("D7,J16").value = "Total"

If the cell addresses D7 and J16 are fixed and will never change, then you could to it this way as well...

[D7,J16] = "Total"