clear

Hello, I am attempting to put together code that will clear a range of cells from one worksheet, and then a separate range from another worksheet afterward. I'm getting a compile error, "wrong number of arguments/invalid property assign". I am not exactly clear on how to set the worksheets as...

Hi can anyone help please, I have the following code that clear the contents as well as the formulas on my spreadsheet. Can any tell me please how not to clear the formulas . Thanks Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) 'Modified 6/18/2019 3:09 PM...

In the Home tab, when I click "Format Painter", it opens the Clipboard. Sometimes there is an item there called (preview not available). I will hit Clear All but it doesn't get cleared. Also, when I Copy my selection in order to add to the Clipboard, nothing happens. Anyone know what is the issue?

I have two listboxes, lboFY and lboCY. If the use makes a single select or multiselect on lboFY, I want to clear all selections that may have been selected in lboCY and the other way around If the use makes a single select or multiselect on lboCY, I want to clear all selections that may have...

I have the below code which clears specific cells after a worksheet is emailed. I need to add TextBox1, TextBox2 and TextBox3 to the code to clear contents also. any help adding this into the below VBA code? MsgBox "Your email was sent." & vbNewLine & "The form will now be reset."...

I've been assigned a task in which I have to automate a survey that resets the option buttons when you click the "clear results command button". I wanted to know how do I clear the option button entries with multiple user forms which are ranged from E63:F88. Also, I wanted to know if its...

Is there a way to clear all cells which have formulas but return 0 value? Im trying to reduce the file size of my spreadsheet. Ive seen some suggestions to use "Find and Replace" and replace all cells from "0" to "" but Excel doesn't allow find and replace on values, only formulas.

Dear Friends and fellows, Yesterday I asked one question which is not clear. it's because of my lack English knowledge. Kindly you all pardon me for that. Here is the clear question. If we take from 1 to 9 as complete 360° rotation. from 1-4 how much degree rotation. kindly write clear...

Hello, I have data consist of invoices and additional informations. I am trying to make up a summary report from it. Example workbook is here: https://we.tl/t-sCoObV14x4 I manually copy/pasted cells based on those dummy filters but what I'd like to achieve is clear I suppose. Btw, user may...

Hi I managed to get some code which found any zeros in range G2:G500 and clear the cell, but now I also need a code that clears the cell beside it in column H. Is that possible? Thanks in advance

I have tried to call my procedures to copy lines and clear cells that work if I run them individually but if I try and click on my red button, "Copy to relevant sheet and clear lines" on the Costing_tool sheet, one of the procedure names is highlighted and the error message reads: Expected...

I have a datasheet with a long list of text from row 2 and below. What I need to do is remove duplicates (clear, not delete), but not on full row, only on range B:D. The duplicates in range B:D should be cleared if their is other rows with the exact same values in the columns A, C, D and Q...

Hi all, I try to understand why my code to clear option button does not work. I know how to clear listbox or textbox from userform, code below ListBox2.Clear TextBox1 = "" But from various optionbuttons in frame, it does not work Here I have 2 frames, with 4 option button in the 1st...

Hi, I am trying to clear the contents (not deleting) for duplicates of the Range A36:G36 and downwards (only the duplicated values should be deleted, the original should not be cleared). Right now I have some code that do almost what I am after. The problem is that it is clearing the full row...

hi, I have a worksheet where I need to delete data in column A by selecting Ctl+spacebar buttons in keyboard and delete button to clear entire data EXCEPT header in cell "A1".. how can I do that.. please help:warning:

Hey all, I have 5 dropdowns in column A (A8, A11, A14, A17, A20) I want to be able to clear 14,17,20 only (20 is dependent on 17, 17 on 14). So if I have a selection in these cells and I change cell A17, I want A20 to clear out. If I change A14 I want A17 and A20 to clear out. I have the...

I have the property set to, "Match Required" for my comboboxes. I have a clear button that resets all of the values of my comboboxes to nothing, "". It keeps saying the selection is invalid after the clear button is pressed. I'll then fill out the form with the correct information and I'll...

I am trying to clear the filters in the pivot tables. I removed the information in the main spreadsheet, but it still remains in my drop down in my pivot tables and is starting to become a big problem. I have tried taking out the report filter field -- removing the main filter than re-adding...

For some reason when I copy an item it is not showing up in my clipboard. It has been working flawlessly until now. When I copy a cell the Paste All and Clear all buttons are ghosted. It will copy and paste using the buttons on the toolbar but nothing shows on Clipboard pane. Thanks.

Dear people, hope that all is well. I desperately need your help. Hoping to at least receive some feedback. So, below is the code. What I need to do is to have an If statement if the sum of the two selections of the listboxes is smaller/bigger than a certain value. I suspect it has something...