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 John Tel 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: Peskarik
  • Content: Threads
  • Order by date
  1. Peskarik

    Question from a rookie

    Hello, THough I have been registered here for a year, I've never really used VBA, until 2 days ago. Decided to learn a little. background and question: I have an open workbook with 2 worksheets: "Shading" and "main". I want to shade every second row in Shading as long as there are values in the...
  2. Peskarik

    Novice problem with If...Then statement

    Hello, guys This is my first post. Moreover, I am novice at VBA. I got a couple of questions. I have this code for expected value calculation: [COLOR=blue] Function ExpVal(vvec, pvec) ' returns expected value for 2 arrays If Application.Sum(pvec) <> 1 Or _ Application.Count(vvec) <>...

Part and Inventory Search

Back
Top