clear a range

Hi Everyone, I'm working on a project and am new to VBA. I've followed tons of tutorials online but I am stuck trying to delete a row in my table based on a selection made in a listbox within a user form. The purpose of the userform is to collect data on reallocating medication that was taken...

Hi All Simply I want to copy data entered in workbook 1 to workbook 2, after it has printed sheet 1 of workbook 2 on Mondays clear the cells of information. I am stuck mostly with clearing on Mondays. partial help would be as welcomed as a complete solution. In more depth: Workbook "Master...

Hi Comunity, I am using formula "Range("F6").FormulaR1C1 = "" " as part of a vba macro to clear values from a cell which is working perfectly. But i was curious if there is a way to delay the clearing to say maybe 15 seconds after the macro has ran? Any guidance?

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 need help with this code. I just want the contents to be cleared until the last row. This code works perfectly when I have it set to delete, but not when I have it set to ClearContents. Range(Range("A2"), ActiveCell.SpecialCells(xlLastCell)).Delete Shift:=xlUp Sub...

Hi All, I am looking to run a macro that clears a range of cells if one particular cell has the word "Leftout" in it. I have the below code but not sure how to run it properly as when i prompt to run it asks for a macro name, obviously I am missing something here. So when Cell F20 has the word...

Hi :) I'm having problems trying to clear the contents in a range I selected. The code, say "w" is 10: Range("A2").End(xlDown).Select ActiveCell.Offset(1, 0).Select ActiveCell.Resize(w, 8).Select Range(Selection).ClearContents I tried that code and it doesn't seem to work, any ideas?