Ok, Actually I have a formula which i wanted to paste in every alternate
cell like F3, F5, F7... uptil the data is filled in the rows.

I am not sure how to do this at one step, as I dont want to select all these
non-contiguous cells using ctrl key and then paste the formula. I thought
selecting the cells at once by running a macro and then pasting it could be
done, but it didnt.
"sebastienm" wrote:

Not sure what you are trying to accomplish.

If you want to Copy/Paste the cells, you can use the syntax:
RangeOrigin.Copy RangeDestination
eg: copy rg to cells starting in Z10
Rg.Copy ActiveSheet.Range("$Z$10")
--
Regards,
Sébastien
<http://www.ondemandanalysis.com


"vijaya" wrote:

I thought I could copy and paste a formula on to the selected cells, but once
i run the macro, the cells get selected but I could not copy paste it, ihow
can i do this

"vijaya" wrote:

I want to select particular cells . Its like got to select every consecutive
3rd cell of a particular column.

Eg: Say column F, I have to select F3, F6, F9...and so on.

I am not sure if we can use macros and range to program this or how to do,
Is it possible to get this way.Pls let me know

Thanks
Vijaya