Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.
Sub mac_deletefalserows() ' ' mac_deletefalserows Macro Dim 3mthlastrow As Long Dim ws As Worksheet Set ws = ThisWorkbook.Sheets("3 Month Letter") 3mthlastrow = Range("A" & Rows.Count).End(xlUp).Row Sheets("3 Month Letter").Select For Idx = 3mthlastrow To 1 Step -1 If Range("O" & Idx).Value = 2 Then Range("O" & Idx).EntireRow.Delete End If Next End Sub
|Fill cell values on multiple criteria skipping blank rows||6||21|
|Excel fill in a form with pick list or drop downs, also need calendar pick||25||22|
|VBA: Insert new column and remove first character of string||9||23|