deleterows

Hi, I just wanted to ask how can I retain the rows if column F or StartString(Font in red) starts with number. Below is my code. Sub DeleteRowsraw() Dim c As Range, DeleteRange As Range, DataRange As Range Dim LR As Long Dim i As Long Dim StartString As String 'change...

Hi there, I have a file with historic data which is weekly updated with a Month to date raw data can anybody help me to delete rows only from the current month? Date is on column B And on column AC I have a =MONTH(B3) formula.

Hi all, I'm new here and I actually have 2 questions, but we will start with this one as this is the one that I've been trying to find an answer to longest. I have a table that pulls data from another worksheet based on the date selected. I have made a quick chart to show the data in that...

Hi I'm hoping someone can help with this I thought it would be simple but my grasp on vba is very limited, I found the below code online and it works however it deletes the entire row I need to delete from column B:DA based on a number from a cell that I retrieve from a combo box (Drop down form...

I get a runtime error using this macro: Private Sub DeleteRows() On Error Resume Next Columns("C:C").SpecialCells(xlCellTypeBlanks).EntireRow.Delete On Error GoTo 0 End Sub It produces an error if there are no rows to delete. How do I prevent the error from happening? This macro is triggered...