Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by jjokol

  1. jjokol

    Select rows between values

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

    Select rows between values

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

    Select rows between values

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

    Easy VBA question....please

    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*...
  5. jjokol

    Go to next cell with a value?

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

Part and Inventory Search

Back
Top