Thread: Event macro: insert row with formulae based on current row, clear selected contents
View Single Post
 
Old 04-16-2020, 08:19 PM
NoSparks NoSparks is offline Windows 10 Office 2010
Excel Hobbyist
  
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default
seeing that your used range is all 16,384 columns
how about trying
Code:
Range(Cells(Target.Row+1, "C"), Cells(Target.Row+1, Columns.Count).End(xlToLeft)).SpecialCells(xlConstants).ClearContents
Reply With Quote