clear cells

hello, New to excel VBA and could use some help. I am looking for a VBA to be able to use on a few different spreadsheets which will be automatically created from an android app that exports to a .csv file. After the csv file is created by the app, I need to be able to: A) clear all cells in...

I have been asked to build a spread sheet to collect data. Sheet1 " collection form" this is where the use enters the data they are collecting. Sheet2 "Report" is where the data needs to be stored after collecting. Goal is to take the relevant data from non contiguous cells in sheet1...

I have a macro that clear the data from some specific cells and i want it to be trigger every time a change the option from a drop down list. How could I do that? thanks!

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

Hi, All: I am really in need of some help getting the code right for my spread sheets. I have multiple sheets. There are form text boxes that are linked with cells on other sheets. Need to figure out the code to create a reset/clear button for the text box as well as the cell that it is...

Hi This is my first post and am new to using code in excel sheets. I have a spread sheet that is keeping track of requested report from 3rd parties. This sheet will need to be password protected as multiple users will have access, so i am trying to sort out a macro that will allow some one to...

Hi This is my first post and am new to using code in excel sheets. I have a spread sheet that is keeping track of requested report from 3rd parties. This sheet will need to be password protected as multiple users will have access, so i am trying to sort out a macro that will allow some one to...

Greetings, i want to clear cells from a certain worksheet name and certain range, so i figured i'd use variables but an error appears saying they can't accept the syntax. here's my code Public Sub deltime() Dim wsheet As String Dim strt As String Dim endc As String wsheet =...

Hello, I feel like this is a dumb question, since I should know how to do this and can't remember. I need to clear the contents of multiple cells in the current sheet. I keep trying Cells("D8:G8").Clearcontents and that is clearly not it. Any help in the correct direction would be greatly...

Hi- help would be greatly appreciated on a macro to clear cells with numbers but no cells with formulas with in this macro: Dim i As Long i = Range("E3") If i > 0 Then ' Copy range Range(Cells(6, 10 + i), Cells(500, 17)).Copy Range(Cells(6, 10), Cells(500...

I've been struggling to remove the empty text string created when I use "" as the false value in formulas. I think I found a way but I wanted to see if anyone has a more elegant solution, and one that would work as a macro. I use the "if" formula to populate many of the cells on my spreadsheet...

Hello, I have a cell A1 in sheet2 linked cell A1 in sheet1 (simply A1='sheet1'!A1). A1 in sheet1 is a data validation drop down menu. I want to clear the content of A2 in sheet 2 everytime the content of A1 in sheet2 changes/is updated. That is everytime the value of A1 in sheet1 is changed...

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

Hello These days I was quite busy with Excel, so I paid many visits to this site, from where I got great advise. For one more I am looking now: What is the easiest way to reset a particular array, say $A$:$AA$30 on the original conditions (font, color, cell unmerged, borders reset, content...

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

i wasnt sure how to explain this the header I have a simple peice of code that clears a few cells. I went back and added another row and therefore updated the code. Now when click the button all my other cells clear as supposed to but my new one doesnt.. but if i run the moduile within the VBA...

Hoping someone out there can help me. I am new to macros and do not have a clue where to start. I have a worksheet called "Entry" and there are certain cells in which data is entered into. There is also a command button that when clicked I would like it to do the following: 1. Copy data that...

I’d greatly appreciate if someone can help me get the Macro code for what I need.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p> </o:p> I am working with range A4:I60 and what I need the macro to do is as follows;<o:p></o:p> <o:p> </o:p> if the value...

If column A has value and column B is Blank I want to clear the data in C & D. The problem is I only want to clear the data in that cell and not the whole row of the columns after. Can anyone offer any advice? Thanks in advance!

I need a macro that auto runs when the spread sheet is opened with the following formula as a condition: =IF(LEFT($B$2,5)>=LEFT(A35,5) if this is true, then I want it to clear the selected cells, if false then "". I am a novice using macros and all I have written is simple macros that format...