clearcontents from range

I am making a funnel management tool and I am trying to use .AutoFilter to clear contents in a row on Table 1 if it states "installed", "scheduled", or "cancelled in the "stage" column. I do not want to delete the rows entirely because I want to keep the number of rows in the table as 100. I...

Hello all! I am extremely new to VBA, so my question may be dumb or simple, but I haven't been able to find the answer anywhere... I am trying to make a sales tracker with a table range from A2:G103 including headers. Column G in that table will include a dropdown to select options such as offer...

Hello all, I am trying to clear only the numeric values from column E. With my little knowledge (and help from google) I have created this Sub ClearContentsITEMS() ActiveSheet.Range("E1", Range("E" & Columns("E").SpecialCells(xlCellTypeConstants, xlNumbers).Row)).ClearContents MsgBox...

<code class="western">I have one line in my code that deletes the data in the first cell to the right of a found search in a specified range. I would like to increase that ClearContents from 1 cell to 3 cells and I just can’t seem to find what that code is.</code> <code class="western">...

Hi everyone! I know I am way overthinking this, but I can't figure out a more efficient string of code. I want to be able to clear the contents of a range of cells in the same row as a cell that changes. So I change cell B10 and it contents are cleared in cells C10:Q10. I want to be able to run...

Hi, I need some help in making this code short and simple. Is there a way to do that? Thanks in advance. Here's my code: [code]Sub ClearData() With Sheets("NPS") .Range("A2", .Cells(.Rows.Count, .Columns.Count)).ClearContents End With With Sheets("QFY") .Range("A2"...

I understand a "blank" cell may contain spaces or other non-printable characters. If I want to ensure a cell is empty, i.e. contain nothing, can I do that manually by highlighting a cell or a cell's contents and hitting the delete key? If I want to do that with Visual Basic will...

I need help creating a VBA IF statement. For example this could be used for a budget, a forecast etc. If the value in cell K17 = "F00" of Sheet1 then clear the values (not formats) of the cells in the Named Range "OneElevenSalary" of Sheet2. If the value in cell K17 = "F01" of Sheet1 then...

Hello, I'm attempting to clear the contents from a range of cells on rows where a cell string may equal R, X, XX, Y, Z, ZX, #N/A. The macro runs fine until it gets to a cell that contains #N/A. Any idea how to get this to work? Sub Recalculate() Dim r As Integer r =...