set value

Hello, I have a worksheet with hundreds of cells with list driven data validation applied. Is there a way to automatically set (i.e. by clicking an object button called "Reset Template") every cell with list based data validation applied to the first value in the data validation list for...

Hi :) I have a graph in an excel sheet that depends on several formulas and data... What I need is a code or a formula which asignes Cell B38 the Maximum of the function in the chart ?? Can anyone help me with this?? Thank you!!

Hello everybody, So far you've all been of great help and now I want to figure out something else. I have a lot of cases were I set a value/range in one sub but actually need it in another sub again. See example below. How can make set values/ranges/etc available in multiple subs? Thanks...

Hello! I am trying to set and lock the values in two cells when the user selects a particular value from a drop down list in another cell. Each of the cells have data validation lists as well and they are all different. Here is what I currently have but it errors on setting the value on...

Hello, I have the following code inside a For loop: ARow1 = Range("A" & i).row ARow2 = Range("A" & "1:A" & z).Find(Trim(Range("C" & i).Value)).row CRow1 = Range("C" & i).row CRow2 = Range("C" & "1:C" & z).Find(Trim(Range("A" & i).Value)).row...

Hello, I have the following code inside a For loop: ARow1 = Range("A" & i).row ARow2 = Range("A" & "1:A" & z).Find(Trim(Range("C" & i).Value)).row CRow1 = Range("C" & i).row CRow2 = Range("C" & "1:C" & z).Find(Trim(Range("A" & i).Value)).row...