| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy paste a formula in multiple cells
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Trying to copy and paste line of text into multiple cells | Excel Discussion (Misc queries) | |||
| how copy formula and only paste into 20,000 cells | Excel Discussion (Misc queries) | |||
| macro copy/paste data from multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
| How to copy and paste same formula in multiple cells? | Excel Worksheet Functions | |||
Threaded Mode
