![]() |
|
|
|
#1
|
|||
|
|||
|
Code:
Sub cpypste()
Dim InputCells As Excel.Range
Dim OutputCells As Excel.Range
'Show input box to get range of cells that want to copy
Set InputCells = _
Application.InputBox(Prompt:="Select Cell / Cells To Copy", _
Title:="Copy Paste", Type:=8)
'Show input box to get where they want it paste
Set OutputCells = _
Application.InputBox(Prompt:="Select cell where you want paste", _
Title:="Copy Paste", Type:=8)
'Copy range of input cells
InputCells.Copy
'Paste it into output cells reference
OutputCells.PasteSpecial (xlPasteAll)
End Sub
|
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Table of contents problems with arabic words | Baby_1 | Word | 0 | 07-20-2017 01:36 AM |
Clearing form
|
wpryan | Word VBA | 2 | 09-05-2015 01:06 AM |
| Word 2011 for Mac - problems with table of contents | tepose | Word | 1 | 09-28-2014 03:36 PM |
Table of Contents problems
|
lsmcal1984 | Word | 1 | 08-21-2013 11:51 AM |
Table of Contents problems
|
hassanfadil | Word | 2 | 06-02-2011 12:05 AM |