Help with Autofill

[maju]

How do i write a macro to autofill Country USA in column b until the end of
the cell with no data. Assuming i have more than 1,000 record. So whenever i
run the macro, it will automatically populate.

Thanks

 

[Jim Rech]

If you have data down column A (unclear from your post) you can select the
cell with USA in column B and double-click the fill handle in the lower
right corner of the cell selector.

--
Jim
| How do i write a macro to autofill Country USA in column b until the end
of
| the cell with no data. Assuming i have more than 1,000 record. So whenever
i
| run the macro, it will automatically populate.
|
| Thanks
|
|

 

[maju]

No i dont have data. i want it to load up with the data

Thanks for ur quick response