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 Mike Lewis 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: *

  1. nikohl

    VLOOKUP IN VBA

    Hi there, I was wondering if there was a VLOOKUP in VBA that I could use? I'm fairly new to VBA so please bear with me. I'll quickly explain what I want to do, just to put you in context. I have two files, a source file and a destination file. The source file has account#'s and data...
  2. nikohl

    Counting Data and Rows Array

    Hello Skip, Your function works like a charm. I wish I could give you something in return, as I don't like to get anything without giving something back...if you ever have a Java/C++ question, let me know! I also agree with you that good table construction should not have empty rows, but the...
  3. nikohl

    Counting Data and Rows Array

    Hi Skip, I don't know if I understand the Range object correctly, but from what I understand it simply returns "cell or a range of cells". But if I know my range of cells, than I wouldn't have to create a function to find the last row there is data in. Also, if I put a few empty...
  4. nikohl

    Counting Data and Rows Array

    Hi There, I am fairly new to VB, so please bear with me. I am having trouble counting rows of Data in my worksheet. I don't want to know how many rows are in my selection, or how many rows are in my worksheet, but I want to know exactly the row number where my last data cell appears. Here's...

Part and Inventory Search

Back
Top