macros in excel

  KILLBILL3 14:24 18 Jul 04
Locked

hi, i have a project in excel and im trying to paste values from one sheet to another. i have this macro working (see below for code)

Range("E3").Select
Selection.Copy
Sheets("order").Select
Range("B9").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("userscreen").Select
Range("A2").Select
End Sub

i need, after 'Range("B9").Select' to insert a cell so that, when i paste the values, a list is created allowing me to tally up a total.
cant work out what code i need as im not too good with the VB code. thanks

  KILLBILL3 14:29 18 Jul 04

Range("E3").Select
Selection.Copy
Sheets("order").Select
Range("B9").Select
Selection.PasteSpecial Paste:=xlValues,
Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("userscreen").Select
Range("A2").Select
End Sub

  pc moron 14:35 18 Jul 04

You can use Range("B9:B20").Select to select cells B9 to B20, say.

Your source and target ranges must be the same size and shape.

This thread is now locked and can not be replied to.

How to get Windows 10 for free | How to install Windows 10: There is still a way to avoid paying…

1995-2015: How technology has changed the world in 20 years

Alex Chinneck’s giant ice cube Christmas tree at Kings Cross

Apple rumours & predictions 2017: The iPhone 8, new iPads, and everything else you should expect fr7…