Data filling in excel column without for each loop

Hi Guys,
Can anyone let me know how to fill the same data in a column till thr last row.
Manually we do, ctrl+shift+pgdown and ctrl+D.

Thanks in advance.

You can use while loop by giving the count.

1 Like


Found this activity.

Input -

Source Range- you can give the range of your first row.
Destination Range - You can give the range from 2nd row till the last row.


1 Like