| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
get the value of a formula in cell B1 into cell A1 without changing my current cell selection
Can someone tell me how in an Excel macro I can get the value of a formula
in cell B1 into cell A1 without changing my current cell selection? THANKS! Mike |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get the value of a formula in cell B1 into cell A1 without changin
You can give this a try... It does not change the cell selection nor does it
require sheet 1 to even be the active sheet... Sheets("Sheet1").Range("A1").value = Sheets("Sheet1").Range("B1").value -- HTH... Jim Thomlinson "News" wrote: Can someone tell me how in an Excel macro I can get the value of a formula in cell B1 into cell A1 without changing my current cell selection? THANKS! Mike |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get the value of a formula in cell B1 into cell A1 without cha
Just use .Formula instead of .Value in both instances.
-- Charles Chickering "A good example is twice the value of good advice." "Jim Thomlinson" wrote: You can give this a try... It does not change the cell selection nor does it require sheet 1 to even be the active sheet... Sheets("Sheet1").Range("A1").value = Sheets("Sheet1").Range("B1").value -- HTH... Jim Thomlinson "News" wrote: Can someone tell me how in an Excel macro I can get the value of a formula in cell B1 into cell A1 without changing my current cell selection? THANKS! Mike |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
get the value of a formula in cell B1 into cell A1 without changin
Wow! Things are easy when you know stuff. Thanks Jim!
Mike "Jim Thomlinson" wrote in message ... You can give this a try... It does not change the cell selection nor does it require sheet 1 to even be the active sheet... Sheets("Sheet1").Range("A1").value = Sheets("Sheet1").Range("B1").value -- HTH... Jim Thomlinson "News" wrote: Can someone tell me how in an Excel macro I can get the value of a formula in cell B1 into cell A1 without changing my current cell selection? THANKS! Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the color of Cell Selection? | Excel Discussion (Misc queries) | |||
| use other cell information to put formula in current cell | Excel Worksheet Functions | |||
| How to make last cell in current selection the activecell | Excel Programming | |||
| formula won't paste from one cell to another with current cell inf | Excel Worksheet Functions | |||
| formula, move to previous cell when the current cell=0 or empty | Excel Discussion (Misc queries) | |||
![News[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
