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...
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...
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...
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("g128:dv128")
Box = UBound(testarray)
counter = 1
While counter <= UBound(testarray)
MsgBox...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.