clear contents

Greetings, I need help clearing cell (B4) when the value in B2 Changes. :confused: I'm Stumped. . .

I would like to clear my data in columns A,B,C in 7 of my worksheets in my workbook. I need help creating a VBA for that? Any help is appreciated.

Hi, I am trying to code out the following scenario for a macro: If cell A# contains "total reconconciled portfolios" then clear contents of columns B# & I# Essentially I am trying to clear the N/A's from columns B & I in the specific rows where column A includes that phrase. I can't clear...

I'm working on a number of macros to automate some reports I run at work and have hit another wall! <style type="text/css">#avg_ls_inline_popup { padding: 0px; overflow: hidden; position: absolute; z-index: 9999; margin-left: 0px; margin-top: 0px; width: 240px; word-wrap: break-word; color...

I need a vba that could clear the cells that are in yellow and leave all the white cells then shift up. Any help is appreciated! <TABLE style="WIDTH: 308pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=410 border=0><COLGROUP><COL style="WIDTH: 123pt; mso-width-source...

Hello...<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I need a little bit help... I think it should be easy code.. Looking to clear content in a row based on a value in a column. I am trying to clear all contents in a row based on the value of "Yes" in...

Is there a simple code that can look only at specified sheets in a workbook and clear just the cells and checkboxes that are not locked while at the same time keeping all the formatting in-tacked including any merged cells? i.e An area for notes comprised of many merged cells and specific...

I am working on a multi-sheet workbook that captures data over a one year span. After the new year I would like a script that backs-up the current workbook, saving it with a specific file format, something like: "string cell reference"," ","old year". The tricky part is when it is finished...

Hi, I'm working with the following: Sub SendtoInvoice() With Worksheets("Invoices") .Range("$A$18:$I" & Cells(Rows.Count, "I").End(xlUp).Row).ClearContents End With With Worksheets("Combined Accounts") .Range("A1:I" & .Cells(Rows.Count, 1).End(xlUp).Row).Copy...

I have a form that has four listboxes and a command button. The command button runs a macro that starts a query using the choices of the 4 listboxes as parameters. If nothing is selected in a certain listbox then records with any value in that related field are returned. This all is working...

I have a form with 4 listboxes and a command button. The command button runs a macro that runs a query using the list boxes as parameters. If no value is chosen in a list box, records with any value in that field are returned. This all works great. I'd like the users choices to clear after the...

Hi, First I want to say i'm new to this forum and already it has been a great help. Looks like there are a lot of really experienced people on here. I have a few cells that use data validation to generate a drop down lists from ranges elsewhere on the sheet. Some of those cells are dependent...

Hi the follwing piece of code finds the left three chars of cell h116 in rng m44:m75 and clears contents of the cell. I would like to modify it so that it checks for a range of different characters i.e in H116:H147 (what i thought was the obvious did not work);- With ActiveSheet For Each...

This is my first post. I have spent the better part of the day trying to adapt some of the code found here. What I want to accomplish is to clear a range of cells if the value of another cell does not equal a specific value. I have been able to get a macro to work but it is manual. I need the...

hey everyone i'm using a table like this one : A B C D E 1 Main | value | value | value | value 2 Extra | value | value | value | value 3 Main | value | value | value | value . . n Extra | value | value | value | value i want to delete every cell in column "E"...

Hi, I am using this command to clear a range of data in excel Worksheets("approved").Range("A5:U250").ClearContents but it is showing me an error. Does anybody know why or what I am doing wrong?

I find different threads on MR. Excel about empty cells that are not really treated by excel as being empty. As soon as I use "" in a formula, Excel will still recognise this as a populated cell. Since they seem to be 'older' discussions, I kind of hope that Microsoft has found a solution for...