clear cell contents

I have the following Table in my macro-enabled excel file Table 1: My goal is to clear cells in Column D only, if a cell value (in column D) = 999, before I close this workbook. User can create a new record(s) in this Table and a new cell value in...

I have a cell "intsel" that changes based on the value of the drop down "intseltext". "intseltext" is a list and depending on what is selected "intsel" value changes from 1-4. I would like to clear the value (not the formatting) from cell "digs" depending on the value of "intsel". Therefore...

I currently use Excel spreadsheet to enter time sheets before I send them off to be processed. I currently use the current week time sheet (adding and deleting employees as needed) - and then after I enter the weekly time I save as the current week but use SAVE as new workbook and clear cells...

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

Hi guys, just simple fast one - Any idea why if I put into my code only the first line below, clearing of the whole sheet does not work & if put another one then it is working.. ? Checked for protected, merged etc.. nothing such like this there.. ;o)...

I have a block of data that comes from CSV and is saved as XLSX. The cells below this block look blank but fail an "is blank" test. I don't know what this condition would be called to google how to identify them. What I need is a VBA string that goes to the end of a block of numbers but stops...

I have a worksheet with a row for each day of 2016. There are formulas, conditional formatting, etc. Now I want to create an empty 2017 version. I thought I'd only have to copy and (somehow) empty the contents (each day's data), but everything I try removes everything; contents, formulae...

I've been trying to do this for a couple of days and I've made some headway but I'm struggling with it. I have made the macro I want but it's the activation I am struggling with. Range("B" & ActiveCell.Row & ":I" & ActiveCell.Row).ClearContents That is what I want to activate but I only want...

I am totally new to this.....But I need help with a macro that will clear cells that are high lighted Red I am trying to make a line plot with the combined good values from columns x,y,z x5:z21000 Excel 2013 Red color is rgb 255 Sheet name is " Curve Data " I...

Hi there! I am fairly new to VBA and brand new to mrexcel.com so please be as detailed as possible in responses (thanks!). My issue: I have a data table called "DataEntry" It has four columns (i.e. fields) - JobType, Rate, Hours, and TotalPayment. JobType is a dropdown list of choices (i.e...

Hi Guys, Bit of a newbie here. I'm working on a very large set of data. Each column contains over 20000 values and I've got a bit of a dilemma. I'm trying to create a macro that can find any values between 0.0401 and 0 AND any values between -0.036 and 0 and clear the contents as well as...

I've run into a cell where I can see the contents but can't clear, delete, format or copy it, Contents of other cells can be copied over top but when the cell is deleted or cleared, the original untouchable contents are back! I've tried the basic HOME>CLEAR>CLEAR ALL and DELETE. Any suggestions...

Re: clear certain cells in a row (on 2 sheets) based on a cell value Hi all, I have a workbook which contains the contents of medical packs. It has 2 sheets of relevance: STRAT Consolidated -Contains bulk of data Ordering -Contains copies of other sheet cells filtered to only show rows...

Hi Everyone, Currently using Office 2010, Windows 7 I'm looking for code that will clear only the cells in named range [TOT_TIME1] if the cells (same row) in named range [CAT1] are empty. I've tried the code below, but keep getting a "Type Mismatch" error. If [CAT1].Value = "" Then...