How do I select multiple cells of a particular column using macros and Range.

I dont want to use ctrl key and select as I have many cells of one
particular column to be selected(something like 1000)

I wanted to copy a formula into these selected cells, once i select the
required cells

Thanks
Vijaya