Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can someone assist me with some Excel VB code?
In the example below, I want to cut the date from the current worksheet (Sheet1) and paste it into multpile cells in another worksheet (Sheet2) within the same workbook. What is the best way to reference each worksheet? I tried Sheet2! but that didn't work for me. Range("A1").Select Selection.Cut Destination:=Range("A1,B1,C1") 'this needs to be pasted in a new worksheet within the same workbook. Many thanks if you can help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
VB Code Question | Excel Discussion (Misc queries) | |||
VBA code question | Excel Discussion (Misc queries) | |||
question about excessive code in replacing #N/A when using VLOOKUP | Excel Discussion (Misc queries) | |||
Easy VB code question | Excel Discussion (Misc queries) | |||
syntax question - cell references in VB code | New Users to Excel |