I need to use VBA to filldown without formatting like you can do rightin Excel (drag the fill handle down and then select the option for"Fill Without Formatting").Does anyone know how to do this?
Have you tried recording a macro while you do it manually?
I can't believe I forgot about that method! That gave me the coderight away.