| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pasting Values of range to another range
Thanks in advance for any help
Usually I like to use something like Paste multi-cell range to a single cell (similar to paste All) Sheets(1).Rng1.copy _ Detination:Sheets(2).Range("A1") or Paste multi-cell range to an identically sized range (similar to paste value) Sheets(2).Rng2.Value = Sheets(1).Rng1.Value Is there a way to amend the first code into a paste value version, without defining the full paste-to range? Thanks... -- steveB Remove "AYN" from email to respond |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT or SUMIF if any values in a range equal any values in another range | Excel Worksheet Functions | |||
| Cond. Format Data Bars of range based on values of another range | Excel Worksheet Functions | |||
| Find a range of values in a range of cells | Excel Worksheet Functions | |||
| Find dates in a range; then sum values in that range by a criteria | Excel Discussion (Misc queries) | |||
| Searching a range and copying values into a new range.... **Please help** :( | Excel Programming | |||
Threaded Mode
