Code needed to fill up blank row

[jp16]

My user has left many empty row inbetween date. For example, A1 = 01/01/2018, A2:A20 is blank. Then A21 = 02/01/2018. I need a code to fill up all the blank. Example, A2:A20 = 01/01/2018.

[ikboy]

try this:

Please Login or Register  to view this content.

[jindon]

Please Login or Register  to view this content.

[jp16]

Hi,

lets say i have Name the Range in name manager, lets say "Datelist""

Can i insert the "Datalist" inside the code?

Please Login or Register  to view this content.

[jindon]

Where is "Dat(ea)list"?

[ikboy]

assume "DateList" is your example [a2:a23]

Please Login or Register  to view this content.