tags:

views:

92

answers:

1

How can I write a one line macro to write two different words in cell A1 and A2?

A: 

Why do you need it to be one line? The obvious two line solution works fine... If you really want, end the first line with a colon and move the second line u, but this is functionally identical. :)

Like this:

Cell1.FormulaR1C1 = "foo": Cell2.FormulaR1C1 = "bar"
jheriko