Fill In formula with VBA

[Gargoyle82]

Hi, quick question, I want to write an Excel VBA macro to emulate the Fill Right functionality of excel including date series, color formatting etc.

For example, I have my cells C10:C20 and I want to fill right to F10:F20 Can this be done quickly in VBA?

[Leith Ross]

Hello Gargoyle82,

To fill across the range use copy and paste special.

Example:
Range("C10:C20").Copy
Range("D10:F20").PasteSpecial xlPasteAll
Application.CutCopyMode = False
Range("C10").Activate

Hope this helps,
Leith Ross