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!

  • 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!

Search results for query: *

  • Users: jjokol
  • Content: Threads
  • Order by date
  1. 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...
  2. 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*...
  3. 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...

Part and Inventory Search

Back
Top