locked paste

  1. P

    Check locked Cells

    Hi All I have a bit of code to help me Paste Values Sub PastSpec() If Selection.Locked = True Then Exit Sub On Error GoTo ErrHan Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False ErrHan: Exit Sub End Sub I recorded part of it and...

Some videos you may like

This Week's Hot Topics