Search results for query: *

I am running Windows Vista Home edition SP2 on a 64-bit laptop with all available Windows updates. For the last few weeks (don't remember the exact date) I have been randomly unable to resize columns in Windows Explorer when browsing in any viewing mode (I am usually in details view, which is...

For this section, a simple "COUNTIF" will work just fine. I was only trying to use autofilter to make my life easy for the rest of the code. But, I need to call from a cell, and I can't do autofilter that way. So, this part of the code is fine. Now I just need to work on the rest of the...

Really? Wow. Not at all? Ok, I didn't know that. I guess I need to find a different way to approach this. Thanks very much for your help. Sarah -don't panic, I'm mostly harmless-

It is used as an Excel addin and called from an individual cell. "=NewPIRR("fund",$A10,3,PeriodEndDate)" I can't believe it works for you. [sadeyes] I will try recreating this section on a new sheet and test the results. Thanks. Sarah -don't panic, I'm mostly harmless-

Skip, there's different functionality based on whether we're dealing with an index or a fund. But that's not really relevant to this. Loomah, thanks for the suggestion. It didn't work. BUT! That tells me it's definitely a problem with my autofilter. Is there something I'm missing in order to...

Public Function NewPIRR(FundOrIndex As String, _ Id As String, _ PeriodLength As Double, _ PeriodEndDate As Date) _ As Variant Application.ScreenUpdating = False Dim IdRange As String Dim ReturnDateRange...

But thanks for the suggestions! Keep 'em coming! Sarah -don't panic, I'm mostly harmless-

Skip: The code runs through quickly but only gives me #VALUE errors in the cells running the code. PHV: I just get the same results as before. Sarah -don't panic, I'm mostly harmless-

Either one should produce the same result as there are no empty cells in the table. Sarah -don't panic, I'm mostly harmless-

Thanks for the quick reply! FundId is actually a named range and not just a heading. Also, putting the subtotal on my sheet and manually doing an autofilter produces the correct number. So it must be my code. But I don't know what. Halp! Sarah -don't panic, I'm mostly harmless-

I would like to count the number of cells still visible after an autofilter. I know the Excel SUBTOTAL function will do this. I must be doing something incorrectly because this isn't happening for me. My code looks like this: ... Range("Fund_table").AutoFilter Field:=2, Criteria1:=Id...

Before I worked here, the guy before me wrote an add in for Excel. There is a handy little Development tab to accommodate VB, so that is what he used to write it. The problem is that we use this function in over a hundred cells and his function is reeeeally slow. It takes usually 5 to 10 minutes...

I am using Image Manager from the Windows AIK toolkit to create an unattended answer file to image the computers in our lab. I would like to be able to join them to our domain without doing it manually for each computer. Here's the problem. The component for doing this (called "UnattendedJoin")...

PS. I also love being short Sarah -don't panic, I'm mostly harmless-

Well, MY plan (waiting to see what His plan is) is to go into the work force for maybe a year or so to pay off my student loans, so I'm not in debt when I start asking for money. I've always been interested in Wycliff Bible Translators. I love languages. (I wish I had the time to learn every...

Apparently this IS the right places. Sarahnade(n): 1.I love to sing, all the time. Sarah + serenade 2.I'm small but slightly explosive. Sarah + grenade 3.Me, if I were a juice. Sarah + lemonade I'm from Austin, Texas. Also College Station where I attend Texas A&M University (WHOOP!). The...

I had no idea there was one of these! Oh boy oh boy! I just LOVE introductions. I'm Sarah. I'm 21. I'm going to school to be a computer programmer. I'm going to be a missionary, so we'll wait and see how well those two fit together. Sadly, I was born in the wrong decade. I shoulda beena hippie...

Wow, I should post here more often. [tongue] Purdy stars. Sarah -don't panic, I'm mostly harmless-

Actually, that blog is not quite right (what? the internet is wrong?). //this is a whole other topic, I'll try to be brief Tithing is an old Jewish practice that has continued in the modern church. Setting aside money (or whatever else) to give to the church, for God's use (like mission work...

aha! A self-fulfilling reputation. That's odd, but it makes sense. Sarah -don't panic, I'm mostly harmless-