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

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
"maju" wrote in message
...
| 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
|
|

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

Thanks for ur quick response

"Jim Rech" wrote:

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
"maju" wrote in message
...
| 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
|
|