You can still use this method, in advance define your named range by
selecting all cells using either code or from the keyboard ctrl key then
Insert-Name-Define from the menu, add a name for the range and press Add.
You can then copy the formula to this named range.........

Range("A1").Copy Destination:=Range("mixedRange")

--
Cheers
Nigel



"vijaya" wrote in message
...
I dont have consecutive cells ,I have cells like G3, G6, G9... uptil G500
or so
How should I copy paste the formula

"vijaya" wrote:

Hi
I wanted to copy and paste a formula in 500 different cells . I dont
want to
manually select the 500 different cells.

How can i copy paste the formula