Search results for query: *

You were right, my logic wasn't correct, but I've made the needed changes, double checked the values, and I still get the subscript out of range error...

I keep getting this error (Subscrip out of range.)when I try to run the code below. Everything should be in the code that you would need to help. I've had this problem before when I try to reference a range using a variable for the parameter. Is there any way to do that. I really don't want...

I have searched my computer for the libssl.so file, and it is in fact present. I have Apache setup to where DSO should work. So, I'm still stumped.

When I uncomment the LoadModule and AddModule lines for mod_ssl. I get an error saying that apache won't start up b/c it can't load libssl.so into the server. In my case it says reason unknown. When I comment the lines out, it works fine again. I am currently on a Mac, running 10.2. Thanks...

I own both a Mac and a PC. I am trying to code some VBA applications on my mac at the moment. I don't think it has VBA 6 and I need the InStrRev function that is only in VBA 6. Does anyone know where I can get VBA 6 for Mac? Also, if I code a VBA application on my Mac, does anyone know if it...

I am wanting to get the path and filename of the active workbook without having to prompt the user to enter it. For example, I have file D:\Documents and Settings\John Doe\Desktop\Test open. I want to know if VBA can harvest that info using the ActiveWorkbook tag, or do I have to prompt the...

I currently run the network for a small business. I am concerned with things being on the computers that my employees could use to waste time. (Games, Messenger Services, etc.) I am actually wanting to know of a way to block the usage of Windows Messenger by my employees. I have read that the...

Okay. I answered my own stupid question. I hadn't set counter to 1 BEFORE it went to the case statement. After doing that it works, but it doesn't loop through all the worksheets in the active workbook. It goes through the case and if statements once. I need it to go through as many times...

I keep getting "Run-time error '9': Subscript out of range." I am trying to make the code let me copy and paste a series of ranges without having to manually input the ranges and worksheets for each copy and paste operation. To try and clarify, I have 7 different worksheets that I need...

What I got out of your postings is that the UBound function only finds the highest row that is filled. What I am actually trying to accomplish is to take some data that is entered into noncontiguous rows, assemble it into an array, determine the frequencty of any given ranges of numbers (i.e. 1...

I am trying to set a range as an array, and the UBound keeps returning a value of 1. Below is the code... Sub TestArray() Dim testarray As Variant testarray = Range(&quot;g128:dv128&quot;) Box = UBound(testarray) counter = 1 While counter <= UBound(testarray) MsgBox...

I figured out my problem. I wasn't saving the event handler in the right spot. I had it as a general module and it needed to be saved at the sheet level to work. It works great now though. Thanks for the help.

This is probably a real basic question, but I have to ask it anyway. I have entered the VBA code and am unable to run the procedure. I see that it needs values passed to it. Do I need to call this procedure from another and pass it the variables it needs? I'm lost. Thanks for the help.

I am trying to write a VBA procedure that is called when the active cell in excel is within a certain range of cells. For example, the cell range of interest is C25:C50. I want the VBA procedure to be called with the active cell is one of the cells in C25:C50. I don't know if this is even...

I'm new to this, having stumbled into Apache on my PowerMac G4 and needing an alternative to a long URL. I would just like to know of any good resources to get my Qmail server up and running. I have a working knowledge of Unix and I also have a nice GUI, webmin, that contains the Qmail module...

Thanks for all the help. Now all I've got to do is give the suggestions a try. Thanks again!

I have a Linksys wireless router that has two computers wired to it and one laptop using the wireless feature. I don't get great reception in the other end of the house and the router has two detachable antennae. The connection is like a BNC connection I believe, but it is threaded instead of...

I have a Linksys wireless router. There are two computers wired to it, and I have a laptop that uses the wireless feature. I've read numerous entries about antannaes and such, but I think I might have another solution that I just don't quite know how to complete. This router has detachable...