MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Filldown without formats

  Asked By: Mali    Date: Sep 18    Category: MS Office    Views: 1112

I need to use VBA to filldown without formatting like you can do right
in Excel (drag the fill handle down and then select the option for
"Fill Without Formatting").

Does anyone know how to do this?



2 Answers Found

Answer #1    Answered By: Darrell Harvey     Answered On: Sep 18

Have you tried recording a macro while you do it manually?

Answer #2    Answered By: Bethany Hughes     Answered On: Sep 18

I can't believe I forgot about that method! That gave me the code
right away.

Didn't find what you were looking for? Find more on Filldown without formats Or get search suggestion and latest updates.