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!

Search results for query: *

  1. rambob

    Excel - Visual Basic

    Acron, Thanks very much...that worked like a charm!
  2. rambob

    Excel - Visual Basic

    I'm trying to use the EXCEL function, MIN in a macro. I use the exact syntax from HELP but it still errs. The syntax I'm using is, myValue = MIN(B59:B71) The error I get is, "Compile Error, Expected: list separator or )". Can anybody help?
  3. rambob

    Defining a Range in Excel

    Thanks very much guys...both of these work well. I really appreciate your time and responses.
  4. rambob

    Defining a Range in Excel

    Skip, What I found in the other help site was that you could define a range by the (beginning row, beginning column, for howm many rows, for how many columns). So, in my original example, I would define a range from A2 to E5 (starting at 2nd row, first column for 10 rows and 5 columns). I...
  5. rambob

    Defining a Range in Excel

    This is in a macro so can't use menuing or manual commands.
  6. rambob

    Defining a Range in Excel

    I am running Excel 97 and am getting an error when I try to define a range using the following statement: Set range1 = Worksheets("Testing divisions").Cells.Range(2, 1, 10, 5) I saw this method referenced at another help site. I need to define a range using row and column defined as...
  7. rambob

    Micorsoft Excel

    Thanks for the responses. It turns out it was a different statement causing the error...this one seems to work OK. Thanks again.
  8. rambob

    Micorsoft Excel

    I'm sure this is simple but I can't seem to be able to find the way in Excel to retrieve a cell value. I continue to get a type mismatch error (I'm using a macro) with the following: Dim cell cell = Worksheets("Sheet1").Range("E25").Value

Part and Inventory Search

Back
Top