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 derfloh 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
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
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
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, 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
