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

  • Users: Gatorsbucs
  • Content: Threads
  • Order by date
  1. Gatorsbucs

    Move to the next cell in the loop if blank data is pulled from Screen

    Hello, Was wondering if someone might be able to help with some EB code? My macro currently grabs 10 lines of data (For Y = 10 to 19) from 5 screens (For P = 1 to 5), PF8 forwards to the next page if there is more data. This runs in a loop using data in column B (X) until it is...
  2. Gatorsbucs

    Stop Macro when GetString is "Blank"

    I have a macro that runs on a loop, it is getting data from the mainframe and populating it in and Excel spreadsheet. The one problem I am having is getting the macro to move on to the “Next X” if and when it comes to “Blank Data” in the mainframe. I have the code set to go through 10 pages...

Part and Inventory Search

Back
Top