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

  1. ColdDay

    Want to bypass clipboard. Object var not set error.

    Having trouble with Object Variable or With Variable not set. Will have sheet with different months records. Need to filter, then copy filtered records to a sheet named either "Calendar2" or "PayPeriod2", depending on dates selected. I can get the filtering done, but no luck on the copying...
  2. ColdDay

    Hi-lite duplicate rows.

    Andy, Sorry for the delay in answering your Q. The patient records are in 2 systems (I don't know why) and the super is wanting to see what is in one and not the other. She exported from both and now wants to compare. I'm not involved in the patient records part, I'm just trying to make her...
  3. ColdDay

    Hi-lite duplicate rows.

    I've gotta give both of you a star. Wow. My super saw what I was doing and gave me a new project. Finding duplicates in our patient accounting records. I have to modify the code a bit, but it should work. If I have any issues I'll be back. Thanks for the help! Bill
  4. ColdDay

    Hi-lite duplicate rows.

    I am wanting to hi-lite all rows that are duplicates based on the Number, Job and Date. In the following, rows 4,5 and 6 are dupes based on their same values. Rows 7 and 8 are dupes based on their same values. Same for 9 & 10, plus 13 & 14. Problem is that rows 7 & 8 are not being hi-lited when...
  5. ColdDay

    How to post an excel sheet here?

    Where on this site is info on how to post an excel table or sheet that stays formatted? I want to post some info, but all the columns move together and the headings don't match the columns and everything is a mess. I know how to do code, but not data from a table. Thanks.
  6. ColdDay

    Delete total rows with auto filter

    Just curious. Why does the following give an "Out of memory" error? Is it reading every cell in column A? I wouldn't think that that would be an issue. rng.AutoFilter field:=1, Criteria1:=CStr(Right(Cells, 5)) = "Total
  7. ColdDay

    Delete total rows with auto filter

    Got it! I've been using a .Offset and looping thru the lines looking for the cells without the word "Total". This little bit of code will speed up a currently long process that I use with a couple of procedures. Thanks PHV! Bill
  8. ColdDay

    Delete total rows with auto filter

    If I am filtering and have a resulting set of data, would there be an "ActiveCell"?
  9. ColdDay

    Delete total rows with auto filter

    After reading and thinking about Skip's reply, I realized that in my haste to post, I got it backwards. I want to delete the rows that do not have the word "Total". Hence, leaving the totals and deleting the detail. Sorry for the backwardness. Anyway, I tried PHV's suggestion except with <>...
  10. ColdDay

    Delete total rows with auto filter

    I looked thru past posts and did not find anything that matched my issue. I want to delete the rows with the word "Total" after doing a subtotal. I have done a copy and paste special for my subtotals so I can work on them. I have a few notes in the code below. Sub DeleteRowsWithWordTotal() Dim...
  11. ColdDay

    Remove custom menu code not working

    Strongm, Perfect. Thanks. Bill
  12. ColdDay

    Remove custom menu code not working

    I want to add a custom menu when opening a wb and remove the menu when closing the wb. The open code works. The closing code does not. Here is what I have: 'Add a custom menu Public Sub AddTSEMenu() Dim cbr As CommandBar Dim ctlMenu As CommandBarControl 'add new menu control Set cbr =...
  13. ColdDay

    MS Small Business 2000 with XP?

    I am in need of a new laptop to run Excel. I have no desire to mess with Win 7 or 8. I have MS Small Business Office 2000 on my current laptop running Vista. Will the Small Business 2000 suite work with XP? XP Pro? I found the following on the MS site, but I really have no clue as to the...
  14. ColdDay

    VLookup problem caused by sheet issue?

    Hey Skip, At the moment, all is looking well. The report ran as desired. I plan to go back and update my other VLookUps for consistency and hopefully avoid issues in the future. Thanks again.
  15. ColdDay

    VLookup problem caused by sheet issue?

    Skip, I did two things that appear to have worked. Or maybe only one of them did. First, I changed the code to: Dim LastRow As Long 'added Sheets("JobsAll") to the following line LastRow = Sheets("JobsAll").Range("A65536").End(xlUp).Row ' or With Range("D1") .Value = "=VLOOKUP(A1...
  16. ColdDay

    VLookup problem caused by sheet issue?

    The value returned for both columns showing NA are numbers. Col D would be something like .003, .54, .01, etc. Col E will be a whole number such 123, 29, 48, etc. The same result is asked for with the columns showing NAME. Also, the info on the source sheet that has the numbers listed...
  17. ColdDay

    VLookup problem caused by sheet issue?

    Not the value of LastRow (417263330) but instead the row number 2445 resulting in $F$2445.
  18. ColdDay

    VLookup problem caused by sheet issue?

    The value of LastRow is 417263330. It is cell A2445. I've got a few other VLookUp's very similar to JobsAll!$A$1:$F$ that work. Such as: =VLOOKUP(A1, CLNTINFO!$A$1:$Z$" & LastRow & ", 2, FALSE) Isn't the value of LastRow appeneded to $F$. Resulting in the cell range of $A$1:$F$2445? Thanks.
  19. ColdDay

    VLookup problem caused by sheet issue?

    Skip, I'm doing it with VBA to automate a very big process. To do it manually just is not practical. I hope I understood what you were requesting with the following. Also, I'm using XL 2010 and every time I want to paste, the screen flickers so I do not know if I'm doing it correctly or not...

Part and Inventory Search

Back
Top