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. jgarvey23

    IF=IFERROR(VLOOKUP

    ha, you got me there....
  2. jgarvey23

    IF=IFERROR(VLOOKUP

    Skip, My current formula ,'[PBDunkAcc.xlsx]Shell'!C3:C5,3,FALSE),VLOOKUP(C[-2],'[PBDunkAcc.xlsx]Shell'!C3:C5,3,FALSE)+1,1)"] will always increase the prior day value by 1 if present. Except, the IFERROR option won't increase by 1, only change #N/A.. Do you know a way to build that...
  3. jgarvey23

    IF=IFERROR(VLOOKUP

    Hi All, My below code performs a Vlookup based on an IF statement then adds 1 to the prior day business sheet if found. Except, if not found, it returns an #N/A & I have to manually change every cell to 1. I've tried everything e.g =IF(ISERROR(VLOOKUP, =IF(ISERROR(VLOOKUP.. No success. Any...
  4. jgarvey23

    private sub worksheet_change

    SKip, I currently have that in my macro except I would prefer to skip that if I could. Is there no method of writing that formatting rule into a private sub within the worksheet?
  5. jgarvey23

    private sub worksheet_change

    All, I need to use a private sub worksheet_change(byval target as range) for Columns B & C. This code needs to change all data input into Column B & C to the date format of "yyyymmdd". Any suggestions? The below code isnt working... Private Sub Worksheet_Change(ByVal Target As Range) Dim...
  6. jgarvey23

    Efficiency & Speed of code Excel- Attachmate Extra V93

    Skip, Thank you for the quick response. I tried to use Pull = .Cells(i, "A").Text Sess0.Screen.PutString Pull 5,8 & it worked fine. Unfortunately, after inputting the first set of Instring, Inrow, Incolumn coordinates accompanied by data from Excel, the next set of coordinates would be thrown...
  7. jgarvey23

    Efficiency & Speed of code Excel- Attachmate Extra V93

    All, I need to make the below code more efficient and process at a faster speed. 800 Milliseconds is the fastest rate as which Attachmate can keep up with Excel. I tried using Sess0.Screen.PutString Pull, Row#, Col# instead of Pull = .Cells(i, "B").Text ''Closing Price...
  8. jgarvey23

    Excel to Attachmate Extra. Copy & Paste & Loop

    All, Can this thread be deleted? I was able to solve the initial issue. -John
  9. jgarvey23

    Excel to Attachmate Extra. Copy & Paste & Loop

    All, I need help with the below code, I am trying to copy data from Excel & Paste into Attachmate Extra. My columns are constant (I,A,B,D,C,E,F,G,H) while my rows will vary with the amount of data day-over-day. Can't figure out how to build the loop function after my code to run through all...

Part and Inventory Search

Back
Top