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!

Recent content by ColdDay

  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.

Part and Inventory Search

Back
Top