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 derfloh 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. tsteele2000

    Error Message - subscript out of range, please help

    I am getting one error message after another with this! This click event macro should select the specified range of data on the worksheet and export it into a new comma delimited file. I am getting "Subscript Out of Range" on the line "Workbooks(SourceWB).Activate" when I...
  2. tsteele2000

    Error message "Argument Not Optional" Please Help

    I'm coding a macro that is attached to a button. The macro should basically take a range of values from a specified sheet in the workbook (always the same so it's hardcoded) and export as a comma delimited text file to a new file. I copied the code from another website and edited it and when I...
  3. tsteele2000

    If a value falls between 'this time' and 'that time'...

    I'm writing a query and I want to write an expression that looks at a time field, and if that time falls within a certain period, returns a value. Something along the lines of: if(8:59:00 AM>[TimeIn]>11:00:00 AM),1,ELSEIF(10:59:00 AM>[TimeIn]>1:00:00 PM,2,ELSEIF(12:59:00 PM>[TimeIn]>3:00:00...

Part and Inventory Search

Back
Top