Hi, I've developed a macro that pastes values for a highlighted selection even if that selection is filtered. Two questions - have I done this correctly? Is there a way to build in an undo function? Obviously since it's a macro you can't just hit the undo button. Sub PasteRight() Selection.SpecialCells(xlCellTypeVisible).Select Selection.FillRight End Sub Sub PasteLeft() Selection.SpecialCells(xlCellTypeVisible).Select Selection.FillLeft End Sub Thanks All!

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Macro to Paste Values over filtered selection

Thread starter nirvehex
Start date Jul 11, 2019
Tags

end macro selection undo values

nirvehex

Well-known Member

Jul 11, 2019

Hi,

I've developed a macro that pastes values for a highlighted selection even if that selection is filtered.

Two questions - have I done this correctly? Is there a way to build in an undo function? Obviously since it's a macro you can't just hit the undo button.

Code:

Sub PasteRight()
 
    Selection.SpecialCells(xlCellTypeVisible).Select
    Selection.FillRight
   
End Sub
 
Sub PasteLeft()
 
    Selection.SpecialCells(xlCellTypeVisible).Select
    Selection.FillLeft
   
End Sub

Thanks All!