clear

  1. G

    Macro Clear Button

    I have created a clear button on my sheet to reset certain cells to 0 etc. However in some of the cells formulas are also being deleted. Can someone tell me how to correct this problem, leave the formulas intact. Thanks all GT
  2. R

    Clear All Permissions in Data Source Settings Using VBA

    Sounds simple but I cannot find any information on how to clear all permissions in Data -- > Get Data -- > Data Source Settings --> Clear Permissions --> Clear All I have trawled the internet for a while but sadly to no avail. If anyone could atleast tell me where in the object model I can...
  3. G

    Clear Columns from "F" to the Very End

    Columns("F:XFD").Select Selection.Clear Hello All, The code above is working to clear all the cells. However, I would like to use another way instead of just referring to Column XFD to find the very end column. Is there another way to select all columns from "F:to the end" and instead of...
  4. A

    VBA clear contents (number and date formats) but keep format

    Hello, I appreciate if somebody please help me with how it's better to clear contents but preserve formatting. I have a data with dates and numbers. When I use Sheet.Range ("A2").CurrentRegion.Delete this preserves formatting for numbers but does not preserve for dates. When I use Sheet.Range...
  5. J

    Clear cells if

    Hi, I'm looking for a code to delete cells C2:AE2 if AB2="TRUE". I need this for each row down to 2000 - so clear C100:AE100 if AB100-"TRUE" etc. Can someone help with this? Many thanks Jim
  6. P

    Clearing worksheets

    I have a file that i was wondering if there was a way to write this code differently or easier. The file has 7 worksheets and a button page. i want to clear all worksheet and end up on cell A2 of the button page. Here is the code: Dim sht As Worksheet For Each sht In ActiveWorkbook.Sheets...
  7. T

    VBA to clear duplicate dates in column but keep row

    Good morning, Please help me out with macros that would cleared out duplicate dates on column A but keep all rows. For example clear out the one I have it in red. <tbody> A B C D 1 10/15/2019 lesson plans TBA TBA 2 10/15/2019 homework TBA TBA 3 10/15/2019 extra credit TBA TBA 4...
  8. P

    How to Clear a JSON file

    Does anybody know what the command is to reset / clear / refresh a JSON file before the file is loaded with another set of data? Thanks. :)
  9. L

    clear all the data

    vba is placed in a seperate file macro.xlsm my file name sample1.xlsx we have to open the file by vba and clear all the data of sheet1 and save and close the file all files are loacted in same place
  10. L

    clear the data

    my file name is 1.xlsx and sheet name can be anything vba will be placed in a macro.xlsm code has to open the file and clear all the data in column B and save and close the file
  11. R

    how to extract only character's ???

    i have a doubt how to extract only characters from a set of word using only excel ex john17son1992born premkumar12from560077 king0295of99theking how to get output as johnsonborn premkumarfrom kingoftheking please clear my doubt
  12. H

    VBA Excel: Clear the entire col expect A1

    Need some help, How to Clear the entire col expect A1 ? The column contain data & empy so i want to clear the whole column except a1 btw, i had column A column C column D column E column I column J column K need to clear
  13. 3

    Clear filter in Macro

    HI Guys, I have this macro currently to open a closed workbook and copy certain columns to active workbook then close. I would like the opening of the new workbook not to show up, and it must update as I have it. Although my macro does not work if filters are In place, can anyone help me add in...
  14. S

    VBA Clear Content based on certain value

    hi all I have a column with a formula and want VBA to clear those cells taht contain the #Value ! error.. I put together below code, which doesn't error but also doesn't do what I want it to do? Dim find As String find = "#Value !" Select Case find Case Cells(2, 3).Value...
  15. C

    If cell contains specific text then clear contents of a different cell

    If Cell B1 contains specific text, example "In", how to have it automatically ClearContents of Cell A1? would like to make this work for a range of cells if G3:G12 contain the word "In" then have them clear the corresponding C3:C7. Is this possible through Conditional formatting or is a Macro...
  16. P

    Dim as WSS, set multiple sheets as variables, give separate command for each sheet

    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...
  17. M

    VBA Code to clear contents Not formulas on spreadsheet

    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...
  18. D

    Format Painter: Clear All in Clipboard not working

    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?
  19. D

    only allow one list box to have a selection

    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...
  20. K

    VBA code to clear range and text box

    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."...

Some videos you may like

This Week's Hot Topics

  • Importing multiple excel files into one spreadsheet
    Hi, I'm trying to import multiple excel files (with the same format into a single spreadsheet) so that each day's file is listed underneath the...
  • find many based on a certain criteria
    good evening, I hope someone can help me? I have a workbook sheet 2 contains lots of data.... I would like to be able to find anything on sheet...
  • How to copy multiple rows using If
    Hi all, I'm very new to VBA and have written this simple code to copy certain cells if a certain cell within that row contains any data. I need...
  • VBA If statement
    Dear All, I have two dates, where I'd like a message box to pop, if the dates are between this criteria. [CODE] sDate1 = #10/1/2019#...
  • Text Format
    I have a sheet for user to keyin the data. The format of the data can be 451 / 1903, 0012 / 9908 or 00287 / 0099. The number after the "/" is...
  • Syntax errors
    Good Morning, Trying to compile a workbook, I keep getting a few errors. Here are the first two: [code=rich]Syntax Error: Function...
Top