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