Microsoft Office Forums - View Single Post - Event macro: insert row with formulae based on current row, clear selected contents

Thread: Event macro: insert row with formulae based on current row, clear selected contents

View Single Post

Old

04-16-2020, 01:36 PM

NoSparks

NoSparks is offline

NoSparks uses Windows 10

Windows 10 NoSparks uses Office 2010

NoSparks uses Office 2010

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 831

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

NoSparks is just really nice

Default

try

Code:

Intersect(Target.EntireRow.Offset(1), UsedRange).Offset(, 2).SpecialCells(xlConstants).ClearContents

Reply With Quote