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!

Register Log in
  • Congratulations derfloh 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: *

  • Users: mcongdon
  • Order by date
  1. mcongdon

    How NOT to MAI!

    One that always gets me at my place of employment is a sign regarding recycling cans from the soda machine: "Please, Do Not Put Cans, That Are Not From The Machine, In the Bag" I'm often tempted to change it, but I don't because it makes me smile everytime I see it.
  2. mcongdon

    Dell Recovery Partition

    That would be perfect. I don't want to delete it altogether necessarily, but there is no reason for there to be a 10gig partition that only has under 1 gig being used. I'll probably cut it in half and that should help my performance seeing as how I only have 600MB left on my C:\ drive right...
  3. mcongdon

    Dell Recovery Partition

    I'm probably going to end up getting a new computer sometime in the near future after all. If I use EASEUS Partition Master, will I have to do a new install of Windows, or will it delete the partition and merge the free space with my C drive?
  4. mcongdon

    Select first row of data from autofilter

    That's good to know and keep in mind as well, thanks!
  5. mcongdon

    Select first row of data from autofilter

    Never mind- PHV's snippet worked beautifully. For some reason when I ran it step wise in the debugger it didn't work, but when I ran the whole procedure through a command button it worked perfectly. Thanks for all the help guys, it's really appreciated. I'll definitely keep that...
  6. mcongdon

    Select first row of data from autofilter

    That still deleted the column headers, but it didn't delete any of the data I need. I may just add the correct column headers to a new sheet in the workbook and insert a row after this procedure. Here's what my code would be (unless we can think of a way not do delete the headers): Sub...
  7. mcongdon

    Select first row of data from autofilter

    That's definitely what I was looking for, now is there a way to NOT select the headers and cells below the filtered selection? Here's what my code looks like now- it might be rough, but hey, I'm an amateur :-p Sub Step2() ' Filter out xxx and yyy account numbers Sheets("Insert Raw Data...
  8. mcongdon

    Select first row of data from autofilter

    I have an autofilter set up through VBA in an Excel 2007 worksheet. Once it filters, I want to delete all the values it returns and remove the autofilter. The problem I'm having is how to select the first row of the filtered data- sometimes it's row 2, sometimes it's row 456. How do I select...
  9. mcongdon

    Insert Column Alters Formula- Any way to turn off???

    Thanks Skip. I will revert back to the original. The end user asked if I could change it to be easier to read, but I'm starting to realize there was a reason I did it that way in the first place. I never really thought about the insert and delete functions and what the consequences from using...
  10. mcongdon

    Insert Column Alters Formula- Any way to turn off???

    I tried using absolute references, and this works if I were to drag the cell containing the formula to a different location. However, when the data source has a column added into it, the absolute reference will change. For example in cell D1 i have a formula =SUM($A:$A). If I drag that cell...
  11. mcongdon

    Insert Column Alters Formula- Any way to turn off???

    This might be an answer that is super easy, but I can't quite figure out how to do it. I have a macro that inserts a column as part of a larger procedure. The problem is that there are formulas based on this data on other sheets that change when the column inserts. For example, the formula...
  12. mcongdon

    VLOOKUP with Sheet2

    Are they also unique on sheet 2? Meaning 1 AcctNbr on sheet 1 matches 1 Row in sheet 2.
  13. mcongdon

    Dell Recovery Partition

    I will look into the trial versions and some of the freebies too. Worse comes to worst, I'd rather shell out the money for a program and equipment that will get the job done right the first time than fight with freebies for weeks to do what I want. Thanks again for all the help, I'll repost...
  14. mcongdon

    Dell Recovery Partition

    That does make a lot of sense. I'm hesitant to jump to a new computer right now because I love the performance that I get right now, but the hard drive is definitely slowing it down from what it could be. I'll definitely look into this drive. It would probably end up costing me just as much...
  15. mcongdon

    Dell Recovery Partition

    Hi Everyone, I have a Dell Inspiron 6400 Laptop that I bought 3 years ago. Performance wise it hasn't failed me yet, so I'm not looking to replace quite yet. One problem I have is that I'm very low on hard drive space. I recently dropped under 1GB available on my C:\ drive. When I bought the...
  16. mcongdon

    "Blank" cells are being counted as values- clear contents with VBA?

    I ended up using VBA to enter an if statement in column AC. If it met the conditions I specified, then it returned a 1, if not, a 0. This way, I could use the sum function to "count" the records matching my specifications. A lot of my problem stems from this being a template that an end user...
  17. mcongdon

    "Blank" cells are being counted as values- clear contents with VBA?

    Thanks guys! Loomah- I tried to use this code, but I'm not really sure how to make it work. I'm not really much of a programmer, i can record macros and clean them up, but I don't know what to do with the bit you provided xlbo- I tried this and it returns an even larger number than it...
  18. mcongdon

    "Blank" cells are being counted as values- clear contents with VBA?

    Hi everyone, I have an Excel workbook that I'm having some trouble with. Here's the formula that is giving me trouble: =COUNTA('Data'!AB:AB) In the sheet 'Data', there is a formula in column AB like this: =IF(D2<>"Part Executed",T2,"") =If(D3<>"Part Executed",T3,"") When the COUNTA function...
  19. mcongdon

    Zero-Length String Error

    Hi Guys, I have an Access form with a command button that will copy certain fields to the next record to be entered. The code for that button is: Private Sub Command367_Click() Me.BuySell.DefaultValue = "=" & Chr(34) & Me!BuySell.Value & Chr(34) Me.TradeDate.DefaultValue = "=" & Chr(34) &...
  20. mcongdon

    Free office alternatives for older PCs

    Whoops. Disregard that one ;-)

Part and Inventory Search

Back
Top