| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need Macro to Sum Range and Paste the Value into one Cell
Can anyone help with the Excel VB syntax to sum a range and paste the value into one cell. The following code is not working for me: Sheets("Sheet1").sum(Range("F36:f45")) Range("e88").Offset(X, 0).Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Note: the above syntax is in a loop. Thus, the need for Offset(x, 0) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| copy range and paste into every 3rd cell of new range | New Users to Excel | |||
| Macro to copy, paste in a range and then delete | Excel Discussion (Misc queries) | |||
| Copy and Paste macro needs to paste to a changing cell reference | Excel Programming | |||
| Macro to Paste to a Variable Range - HELP | Excel Programming | |||
| Macro to paste a copied range | Excel Programming | |||
Threaded Mode
