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
2009-02-10 11:23:27