clear contents

Hi, how would I clear the cell contents which are formatted as dates in a column if the dates do not fall in between 17:00 from yesterday to 17:00 on the current day? Using VBA. Thank you in advance!

Hi guys I want when i click a cell or macro button, then clear content of specific range and cells

Hi, I have the following bit of code which i use in a userform to reset it. I thought i would be able to use the same bit of code within a standard sheet using a command button linked to the code but it doesnt work, just throws an error at the me.control part. Would anyone know how to adapt for...

Hello, I'm new to VBA and need some help. Im bascially trying to say - look in column C, if the value is "State ID" then clear contents <tbody> Sub ClearRowWith_ID() Last = Cells(Rows.Count, "C").End(xlUp).Row For i = Last To 1 Step -1 If (Cells(i, "C").Value) = "State ID"...

Hello, Still learning VBA, trying to make a UserForm's fields show/hide based on an initial selection. What it should do: In the useform, the first Combobox selection hides and clears the third combobox and two checkboxes. These elements are held within a flat frame that is shown or hidden...

Problem Working with various in-congruent data tables of 100+ columns & 200-500k records, "Clearing Contents" of 'blank cells' takes*: "Blank" Cells Defined - A1:B10; C15:E25; BB2200:BC300000 Ranges contain "blank" cells that Excel counts in Pivot Table summations. - LEN(ranges) = 0 Various...

Me again. A slightly more challenging one this time. I have a worksheet with multiple formula some on hidden rows, all nicely laid out and formatted to make an easy to use standard report. I have the sheet protected from accidental editing by well meaning colleagues. All good! I want to...

Hello All, I have a macro that clears data from a sheet and gets it ready to start a new week, but a few merged cells keep getting their fill color cleared. Now, I can always just have my code fill the gradient colors back in, but I'd rather try to fix what is causing the issue...

Hello, I feel like I am so close to this but I think I am not adept enough at macros to get it right enough to work. And, I have searched high and low and found everything but what I am looking for. I also tried to use the macro recorder but as I have learned it won't work for this. I know how...

Hello all, I have a code that I am using to clear cell contents and formatting, however what I need to do is also clear the contents of whatever is in Column B of the same row(s) that are selected and having the contents deleted. Here's my code: Sub Clear()With Selection...

Hi, I need help writing a code that will clear the contents of cells D10:G10 & I10:M10 if the contents of cell C10 are deleted. I need for the corresponding rows down do D33:G33 & I33:M33 & C33. I am able to make it work for the first row but not sure how to include the additional rows without...

I have about 85 sheets in a workbook that are all very different in which cells are locked and which are unlocked. I need a macro that will "Clear Contents" on all unlocked cells on a sheet. The sheets are (or will be) protected. Can someone PLEASE help me!!!

Hi there, thanks for reading - I'm a total newbie to VBA so this is a steep learning curve for me. I am working on a file for person identifiable information to be collected, but the file needs code to anonymise the information before it can be returned to me. Essentially I have a "Master" sheet...

What's the most efficient code to clear the contents of all row data from the 2nd column through the last column? This is what I use to clear everything: With Sheet("Sheet1").Cells .ClearContents End With But how can I do the same and exclude the first column?

I am needing some code to Clear contents of what ever cell is selected at the time. I would like this to be where I select a cell then press a form control button to clear whatever cell is selected. Thanks as always....

Hello, I recorded a macro to select a range of cells and then clear their contents. When I ran the macro, I got the error message "Compile error: Argument not optional"--I believe the string specifying the cells may have been too long. Following a suggestion on this board (#4 on this page), I...

Hello, Each week I run a report that produces over 2,000 rows. I have to manually go through and delete things, by the time I am done, there may only be 320 rows left. I would apply a recorded macro, but the report is not consistent each week. There may be more or fewer rows depending on the...

New to VBA but feel that using it is the solution to this question: I have text in column F (cells 20 to 199) that changes automatically based on pre-determined time constraints (this is done via an IF formula). I want the 4 cells adjacent to F to clear contents when the text in F changes...

Hi All, Is it possible to create a function that clears the contents of a cell when the criteria is met? For instance, if A1>0 then Clear Contents of A1. Cheers, mem

I have a list on sheet3 that is generated by a user and a list on sheet2 that is automatically provided. What I would like to have happen is when when a macro is run on sheet3 it goes down the list (could be variable in length) item by item and clears any identical values in sheet2. For...