13.value

I'm using this code to try and conditional format the rows with the values shown below. My problem is "Red" is the only color that's working, and i don't know why. Dim i As LongDim Lastrow, Lastcolumn As Long Lastrow = .Cells(.Rows.Count, "A").End(xlUp).Row For i = 1 To Lastrow...

I have a check box to increase a quote by 10%. The formula is multiplied by a cell that contains a 1 or 1.1, depending on whether the check box is selected. I have the following code that won't work, what is wrong with it and what is a more efficient way to write it? Private Sub...

Hello VBA experts, I need to clean up this code. The data set is only 1947 rows and this takes over 3 minutes to run on a pretty fast computer. I know there are many ways to run a process, so I am hoping someone can look at this code and tell/show me what needs to be changed in order for it...