clearcontents

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

I'm needing to clear all contents (or delete entire row) from cells A52:C52 and downwards my problem is that depending on my data I don't know how many rows actually have data in them to delete - and i don't want to crash my computer which has happened when i just did every cell til the end. any...

I'm wondering how to clear contents in rows that have any cells that are not empty with vba from a certain row onwards. So from row 52 i want to clear all contents of any cells. everytime i do this my computer seems to crash, obviously haven't quite got the code right.

I started with this http://www.contextures.com/xlDataVal13.html which told me how to do dependent validation lists. It works well, however I need to force blanks or clear out the Customer. My question is this and I'll use the page above as a reference: If I clear out a Region, the Customer is...

I am trying, when a certain cell changes, to delete the contents of a number of other cells. Because the particular cells will vary, I am referring to them indirectly - named cells contain the Excel references to both the "trigger" cell and the "to erase" cells. Thus the start of my VB...