| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy only bumbers from cells
Your code should work unless you're looking to pull out numbers that are
embedded as part of a formula. I have a SUM function in A1 and when I run your code it places the value (not the formula) in cell B1. Can you provide a little more detail? _______________________ Robert Rosenberg R-COR Consulting Services Microsoft MVP - Excel "Antonis" wrote in message ... Hi I am using this code to copy cell A1 to cell B1 Range("B1").Value = Range("A1").Value How can I copy only the numbers inside the cell without copying any functions or formulas insideit? Thanks for your help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy Visible Cells in Sheet with Merged and Hidden Cells | Excel Discussion (Misc queries) | |||
| How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
| Copy Source Cells to Destination Cells Only when a Change Occurs | Excel Discussion (Misc queries) | |||
| Copy and paste versus copy and insert copied cells | New Users to Excel | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
![Robert Rosenberg[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
