Data filling in excel column without for each loop

Help
1

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.

2

You can use while loop by giving the count.

1 Like
3

Hey,

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.

Thanks.

1 Like