Macro to Fill Down Row

[BLS99covert]

I'm looking to create a macro, one where depending on which the active cell is, if I hit say Ctrl + Shift + D. The macro would fill down the row I selected one row, but there are certain columns I want it to fill down:
I want it to Fill Down columns: A to E, G, I, K, M to P, R to T.

For example, my cursor is in cell N45, I want it to fill down row 45, but only columns A to E, G, I, K, M to P, R to T to row 45.

Can this be done. My testworkbook is attached.

[cemregunay]

Please Login or Register  to view this content.

Paste this code to your sheet code page and try please.

[cemregunay]

And example file

[BLS99covert]

Umm..it did nothing?