Search results for query: *

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.

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...

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?

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

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...

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...

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...

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...

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...

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...

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...

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

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...

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...

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...

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...

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...

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...

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) &...

Whoops. Disregard that one ;-)