That is exactly what I want to do, but I'd like to record the macro to a
shortcut key that will "Fill Without Formatting" whatever cells I have
selected when I press the shortcut key. The problem is that when I try to
run the macro it fills the same number of cells that I selected when
recording it. I would like this to be dynamic.

Does this make sense?

"Shane Devenshire" wrote:

Hi,

Turn on the macro recorder and record the steps - Tools, Macro, Record New
Macro.

When you finish the fill down, open the Paste Option icon, usually near the
bottom right of the filled range and choose Fill Without Formatting.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Mike" wrote:

Is there a way to design a macro that can perform the 'fill down without
formatting' procedure for cells that I highlight? I've tried to write it but
it busts if I select a different number of cells that I used when I recorded
it. Thanks for the help!