We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Sub CopySpecialPasteValuesAndNumberFormats() ' ' CopySpecialPasteValuesAndNumberFormats Macro ' Need to change this to whatever the column is of the active cell ' For reuse throughout the workbook ' Columns("A:A").Select Selection.Copy Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False Application.CutCopyMode = False End Sub
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|does anyone has list of all excel features including the new ones added by 365?||1||19|
|Excel Pivot Table and column chart to display traffic by year||9||34|
|The only paste option available in Office 2016 is paste as text. How to fix?||15||34|
|Would like to change date on excel||6||18|