Search results for query: *

This is the code I've tried - but it doesn't work! Columns A-E have values: Column A is empty until the last row which has a value of X. Column C is the one I'm using as my active column. All other columns have values that I want to examine. At the beginning of each of the blocks of rows that...

Thanks for your suggestions - they work, but I want to execute some code after the figures have been sorted. That's why I wanted a vba solution. Basically, the code needs to: 1. Select rows between "a" and "a". 2. Sort the rows into ascending order according to values in column D 3. Then...

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