| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copy a sum in cell on sheet 1 (not formula) to cell on sheet 2
Hi John
try Change cell to fit your needs Sub Macro1() ' ' Macro1 Macro ' ' Range("B3").Select ' this is where the formula is Selection.Copy Sheets("Sheet2").Select Range("B2").Select ' this is the cell where you want to copy the results Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub "John" wrote: need only the results of a formula to be transferred to sheet 2 ...cannot have the formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| To copy the formula in one cell to another in a seperate sheet | Excel Discussion (Misc queries) | |||
| FORMULA COPY SHEET IN THE OTHER CELL | Excel Worksheet Functions | |||
| how to copy a cell with formula from sheet 1 (data is all vertical) into sheet 2 | Excel Worksheet Functions | |||
| Active Cell Copy And Paste Sheet to Sheet | New Users to Excel | |||
| Copy text from same cell on every sheet to title sheet? | Excel Discussion (Misc queries) | |||
Linear Mode
