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!

Recent content by jane2geo

  1. jane2geo

    How can I ..... Horizontal listing

    New evidence. The cell shift is happening, down range maybe ten columns or so. Not at AE-AF where data pairs are posted.
  2. jane2geo

    How can I ..... Horizontal listing

    That brings the data pairs back, just outside the query range. However, now new updates simply overwrite the old ones. I’m not maintaining a historical record of changes.
  3. jane2geo

    How can I ..... Horizontal listing

    That did it. However, don’t know why but the data pairs now begin in column AO, instead of the previous location AE. Ten additional columns to the right.? The last hurdle is to post only data pairs, when the percentage value in column K changes. Currently the data pairs are saved on every...
  4. jane2geo

    How can I ..... Horizontal listing

    Still only one column K the eleventh column. For Each r In .Range(Cells(2, 1), Cells(.Rows.Count, 1)) returns data column A only. Looking for return data column K only, which is percentages.
  5. jane2geo

    How can I ..... Horizontal listing

    Changing the data type of vPct to Variant now works for column A. Just don’t know the correct syntax for column 11 or “K” only, For Each r In .Range(Cells(2, 1), Cells(.Rows.Count, 11)) returns 11 columns of data.
  6. jane2geo

    How can I ..... Horizontal listing

    For Each r In .Range(Cells(2, 1), Cells(.Rows.Count, 1)), r.value= 20:00 EST For Each r In Range(Cells(3, "K"), Cells(Cells.Rows.Count, "K").End(xlUp)), r.value= 0.52 Both stop code, type mismatch.
  7. jane2geo

    How can I ..... Horizontal listing

    wax on .... wax off" Watch : : vPct = r.Value : False : Variant/Boolean : Class1.qt_AfterRefresh
  8. jane2geo

    How can I ..... Horizontal listing

    The revised data pair location is perfect. Apparently the query range was larger than I thought. Time stamp [cell AE] is good. But still getting that "type mismatch on vPct = .Value" After resetting the macro to run, and re-query, the second Data pair is filled flawlessly as well. Not sure...
  9. jane2geo

    How can I ..... Horizontal listing

    Sorry, moved my test cell to K and M being the cell where the list starts. The r.value is percent. But prior to the code running M is an additional unused percent column. After code execution M or [your "I"] is always time. The key is to get the list to start outside the query range, twelve...
  10. jane2geo

    How can I ..... Horizontal listing

    Had success creating and using a Query AfterRefresh Event. Thanks Master Miyagi, “wax on… wax off”. The code seems to work on the first update but with a type mismatch at vPct = .Value. Upon stopping the debugger, time and value are inserted skipping one column , other cells are shifted to...
  11. jane2geo

    How can I ..... Horizontal listing

    Wow, now you’re over my head. Not sure how I warrant your attention but thanks. Skip I don’t know which event to place the code into. Simply as sub test I had no results. In the work sheet calculate event, the code runs and flickers about 256 times then presto the time and value appears...
  12. jane2geo

    How can I ..... Horizontal listing

    Thank you, I was flirting with that “shift:=xlToRight” just couldn’t get mine to work. However, your sample is only recording the time. I want to keep the history of the G3 value as well, but only when it changes. Column G will have many percentage values, some changing and some not...
  13. jane2geo

    How can I ..... Horizontal listing

    Ok Skip. I’m a beginner I have never used VBA in excel before. As a novice I search for solutions for my needs on at a time. I found code at this site, http://www.exceluser.com/solutions/timetrack.htm, that only updates on a manual change. Then I found wssheet_onCalc code that updated with my...
  14. jane2geo

    How can I ..... Horizontal listing

    That is my range. I also have a cell =A3 to trigger the event. The field is updated via a web query. This is my adaptation of the code at http://wxw.exceluser.com/solutions/timetrack.htm Crude possibly but it works, just need to see the results Horizontally. I would be grateful for any advise.
  15. jane2geo

    How can I ..... Horizontal listing

    I'm using VBA to track dynamic data in excel. This code Works nicely but I want my list to fill horizontally not vertically. Can the new data be added from left to right? Keeping the most recent in the left most part of the range. Thank you in advance. Private Sub Worksheet_Calculate() Dim...

Part and Inventory Search

Back
Top