I can't for the life of me work out how to select rows between values. For example, row 3 column a contains the value "a". The next 6 rows contain different numbers that I want to sort into order, then row 10 column a contains the value "a" again.
How can i programme some vba to sort the...
What's the correct way of asking VBA to evaluate 2 conditions so that they're both true? In the example below, I want 2 conditions to be met before it proceeds:
If Range("C3").Value > 2* Range("C1").Value AND Range("C3").Value > 11.1 then...
Condition 1 = Range("C3").Value > 2*...
One column contains an IF statement [ =IF($A12=1,IF($F12=3,3,""),"") ] that provides a value of 3 if true. There are 20000 rows in this column and only a few values are 3 so how do i jump from one 3 to the next one without having to page down?
I've tried some VBA in a macro:
Do While...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.