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!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
-
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...- jgarvey23
- Post #3
- Forum: Microsoft: Office
-
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...- jgarvey23
- Thread
- Replies: 5
- Forum: Microsoft: Office
-
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?- jgarvey23
- Post #3
- Forum: Microsoft: Office
-
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...- jgarvey23
- Thread
- Replies: 7
- Forum: Microsoft: Office
-
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...- jgarvey23
- Post #3
- Forum: AttachMate solutions
-
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...- jgarvey23
- Thread
- Replies: 3
- Forum: AttachMate solutions
-
Excel to Attachmate Extra. Copy & Paste & Loop
All, Can this thread be deleted? I was able to solve the initial issue. -John- jgarvey23
- Post #2
- Forum: AttachMate solutions
-
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...- jgarvey23
- Thread
- Replies: 2
- Forum: AttachMate solutions
