Selection.AutoFill Destination:=Range("As Long Cell")

[meakashgfx]

Hi everyone,


I need a help. I have column "C:C" with time and date in general format. I want to get the time value in "D:D" column. I have tried Timevalue formula but I had to drag down the cell corner to fill all the rows as long.


Can anyone help me to solve this with a macro?


Thanks in advance!

 

[ritesh2501]

paste it in Column D,

=+TEXT($c1,"hh:mm")

 

[meakashgfx]

thanks! Its working but another issue is that I will use this in VBA so how do I auto fill the "D" column as long the value "C" column?

 

[meakashgfx]

if I use this in a blank cell show 12:00 AM why?

=+TEXT($c1,"hh:mm AM/PM")

paste it in Column D,

=+TEXT($c1,"hh:mm")

 

[ritesh2501]

can you share your sheet...

 

[meakashgfx]