clearing

Hello, I wanted to know if there was a way to clear cells based on a cell having the same value as cell in a table column range. For example, say we are working with table1, A1:C150, A has names, B has extensions, and C has computer names. If an extension in range B1:150 is the same as D1, B30...

Hi, I am sorting out my tables but i notice i have 3 entries of which are related & need some advice. My worksheet has the following. Columns range AI2:AI236 AJ2:AJ236 AK2:AK236 The colums have headers AI = COUNTRY AJ = ITAS AK = ISF When i click any header then look top left of screen i see...

I have a combo box on a userform that is connected with a formula. It's similar to an autocomplete combo box. Anyways, I have my program working fairly smoothly except for the fact that after it narrowing down my search, I will click on SOME options and it clears itself and it wants me to type...

Hi there, I am having an odd issue with my userform. I have one textbox coded TextBox_UniqueReference3 that appears to be automatically clearing its value when I click the add command button on my userform. This is an issue because I have programmed a vlookup on TextBox_UniqueReference3.value...

I don't want to use VBA as this will make it a xlsm file which can be rejected when it enters the company's email system. I have date validated a cell so that only a current or greater date can be entered. However when an incorrect date is entered, a message appears but the incorrect date...

Hello....I need some solution on clearing the data with contents along with format... assume I have headers in Row 4 and want to clear the data from 5th row on wards every time when I run the macro....can anyone help me...below code I created but not working ..its clearing the header when I...

Range(Cells(6, 1), Cells(200, 4)).ClearContents I understand its clearing contents. I don't understand the Range/Cells

I am using the code below to clear cells when I run Macro. The problem my sheet is very long for example. I am clearing every 4 cell in column C starting at C5 and finishing at C1653. Is there a quicker way of doing this code? Sub Clearrange(sRange As String, sWorksheet As String)...

Running Excel 365 Pro Plus. Have a table with approximately 100,000 rows with duplicate entries. Have been using conditional formatting and custom filter to identify and sort these entries. Takes 20-30 minutes to run. However, when I want to use the custom filter for another task, as soon as...

I have a protected worksheet with unlocked cells and a small section of check boxes. I have a "clear form" button that clears the unlocked cells however, it does not clear the check boxes. What can I add to the code below that will clear the check boxes too? Sub ClearUnlockedCells()...

Hello All, I have this code for clearing data from certain range of some sheets in my workbook. What I want the case statement to do is to pick sheets that I want to exclude from the clearing. Sub ClearRange() Dim Wsheet As Worksheet For Each Wsheet In Worksheets Select Case...