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 strongm 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. Frank Melan

    Is it possible to have a range of numbers in a formula?

    I have a formula that counts a size value & quantity for a certain month. I7 is the month cell, K7 is the quantity value for the size. The following formula works if the cell value is static. =COUNTIFS(K7,"4",I7,10)*K7 Is it possible to have a range of numbers in the formula from 1 to 100? I...
  2. Frank Melan

    Code to go to first blank cell on another sheet

    Currently I have basic code to go to another sheet in the current work & code to find the first blank cell on a worksheet. I am trying to combine the two codes, so when selected it goes to the first blank cell on another sheet. Here is the code to go to another sheet it is located on the "TOC"...
  3. Frank Melan

    Code to close down excel application not working properly

    I am currently using VBA code to close excel, rather than several steps. Originally the code worked as expected. Now it closes but gives this error code. "Microsoft Excel has stopped working. A problem caused the program to stop working correctly. Please close the program. Here is the current...
  4. Frank Melan

    Using excel macro to open attachmate Reflection for UNIX and Open VMS Session

    I have searched the internet & have found how to use Attachmate to do stuff in excel, but nothing to open a file. The code I have so far acts like it is going to open, then hangs up on ActiveWorkbook.FollowHyperlink MyFolder. I also get the following error: Run-time error '-2147417851...

Part and Inventory Search

Back
Top