MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.
Sub ClearMeasuringUp() If MsgBox("You are about to clear the entire worksheet - Are you sure you want to proceed?", vbYesNo) = vbYes Then ActiveSheet.Range("B28:D28,F28:H28,J28:L28,P28").ClearContents ActiveSheet.Cells(27, 14).Value = "Diameter" Application.Goto Reference:="Diameter" Selection.ClearContents End If End Sub
ActiveSheet.Cells(27, 14).Value = "Diameter"
|In Excel 2007, how can I lock a value in two cells if "Yes" has been selected in a drop-down list?||7||55|
|I need help with an EXCEL Nested formula.||5||20|
|Automating an Excel Template using VBA and Outlook||8||24|
|Efficient way to copy unique records from one sheet to another||5||17|