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

I assume that you do not want to manually select each individual cell

copy the cell with the formula
highlight the 500 cells
if the cells are not in one block highlight a block hold <cntrl button and
highlight the next block etc...

right click and select "paste"

--
Greetings from New Zealand
Bill K

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

A1 contains formula and it is copied to Range B1 to B500, change references
as required.

Range("A1").Copy Destination:=Range("B1:B500")


--
Cheers
Nigel



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

Nigel,
I have a similar need but the Copy destination needs to be a dynami
range. Could I use your code if I made the dynamic range a named range
ie Copy Destination:=Range("SomeNamedRange") and would it keep up wit
the changing size of the Range?

Thanks for any help

--
Case

-----------------------------------------------------------------------
Casey's Profile: http://www.excelforum.com/member.php...nfo&userid=454
View this thread: http://www.excelforum.com/showthread.php?threadid=48198

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

Yes, this will work, but of course the code will need to be run if the
extent of myRange is changed, so where ever your range gets changed you will
need to run this code.......

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


--
Cheers
Nigel



"Casey" wrote in message
...

Nigel,
I have a similar need but the Copy destination needs to be a dynamic
range. Could I use your code if I made the dynamic range a named range?
ie Copy Destination:=Range("SomeNamedRange") and would it keep up with
the changing size of the Range?

Thanks for any help.


--
Casey


------------------------------------------------------------------------
Casey's Profile:
http://www.excelforum.com/member.php...fo&userid=4545
View this thread: http://www.excelforum.com/showthread...hreadid=481988

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