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

		Microsoft Office Forums > Microsoft Excel > Excel Programming
Event macro: insert row with formulae based on current row, clear selected contents

04-16-2020, 01:36 PM

NoSparks

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

Office 2010

Excel Hobbyist

Join Date: Nov 2013

Location: British Columbia, Canada

Posts: 842

try

Code:

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Macro - Copying and Pasting selected slides (based on selected keywords/criteria) Hi	erickhawe	PowerPoint	0	08-16-2019 09:00 PM
Need macro for automatic point value insertion based on the number of answer choices selected	ganesang	Word VBA	29	08-12-2018 09:38 PM
Need macro for automatic point value insertion based on the number of answer choices selected	ganesang	Word	1	07-31-2018 06:07 AM
a macro that can copy data from copy.xls to our current excel macro.xls based on criteria:	udhaya	Excel Programming	1	11-12-2015 10:12 AM
Need macro to fill data from different sheets based on selected item from drop down	skorasika	Excel Programming	1	03-13-2015 11:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:59 PM.