|
|
#2
08-26-2021, 12:25 AM
|
|||
|
|||
try this, it will paste whatever is copied one cell to the right - no more validation so it will keep doing it if you press the button again and again. Can be improved further
Code:
Sub Copy()
Selection.Copy
Selection.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to paste the value of a selected cell to another sheet?
|
Learner7 | Excel Programming | 3 | 06-30-2019 10:35 PM |
|
Fill blank cell with value from adjacent cell
|
kevinbradley57 | Excel Programming | 2 | 04-17-2018 08:40 AM |
| IF adjacent cell empty Copy from Other Column | ChrisOK | Excel Programming | 8 | 03-08-2018 09:17 PM |
| Increase number in cell, based on value in adjacent cell | scottyb | Excel | 3 | 02-02-2017 03:51 AM |
|
How to conditionally format cells in Col. A if it matches adjacent cell in Col. B?
|
alshcover | Excel | 2 | 06-03-2014 12:50 PM |
Windows 10 
Office 2019
Threaded Mode