Search results for query: *

Thanks! You're right.I got confuse because offset uses 0 but cell uses 1. It works! ljCharlie

I have tried the following: Function numbCols(countrows) As Integer Dim shtAnnual As Worksheet Dim rng As Range Dim numCols As Integer Dim txtInbox As String Set shtAnnual = ActiveSheet 'activate the first cell as a starting point for counting non-empty rows...

Is there a way to activate any cell and make it active in the worksheet at anytime in the program? Any help is appreciated. ljCharlie

Thanks! I found it. It's ActiveSheet and not ActiveWorkSheet. ljCharlie

Thanks but that doesn't work. I got an error saying variable not defined on the word "ActiveWorkSheet" ljCharlie

Is there a way to automatically detect the worksheet name of a workbook? Here's what I want to do. Dim myWorksheet As Worksheet Now, I want to Set myWorksheet to the currently active worksheet. How do I do this? Help is appreciated. ljCharlie

Is there a simple way to determine the number of rows and columns in a workbook? It's hard to specify the range if I don't know the maximum number of rows and columns that I can work with. Any help is appreciated.

Many thanks for your help. The information you provided is very helpful. ljCharlie

Thanks, PScottC, for the explanation. So while the SMTP is sending that 15,000 emails, it will slow down the whole network then, correc? Or we should not be doing any Internet access, correct? What about accessing our network resource, will that affect it too? You mentioned that you send out...

So what kinds of hardware or any kind of requirement do I need if I want to send around 10 to 40 thousand emails at one time? I'm creating a news letter for interested users. ljCharlie

I'm not sure if this topic relates to exchange server but I don't know which forum to ask so I choose this forum. Anyway, I like to know what the maximum limit of emails that SMTP can send out at one time. Any help, suggestionns, or point to a link is appreciated. ljCharlie

Many thanks to you. It works! ljCharlie

Well, I found out that the web browser need to install Remote Desktop ActiveX Control. I'm not sure if this ActiveX control is installed by default or not. If not, then I might not be able to connect to my pc once I'm on the road. One other question, when I instaleld the remote desktop activeX...

I installed the remote desktop web connection service and it seems to be working fine. However, when I tried to connect to it using a browser, I got to the login page but the "Connect" button is not working despite I put in all the information. The "Connect" button is grayed out. Any idea why...

Thank you for the response. Yes, I do have port 3389 open on my firewall and it's working except that I want to access through a web browser. I just installed the tsweb on my personal computer at home. I'll give it a try and see what happens. The problem I have with this method is that the IIS...

What is the best way to connect to my server? I can think of a couple of options such as remote desktop connection and tsweb services. With remote desktop connection, the client has to have Windows XP remote desktop connection application installed. With tsweb, I have to turn on IIS and somehow...

Many thanks for the response but it doesn't seem to do the trick.

The CD/DVD autostart is not working. Any guess why this would happened? When I double click on the My Computer, the CD/DVD drive does not even show the application's icon. Help is appreciated. ljCharlie

First of, I couldn't get the 2-3 pixel gap between the #lftSideMenu and #mainContent, and the #rghtSideMenu and #mainContent to close. Once these gap is closed up, I believed the navigational menu will work. If somehow, this can't be done, is there a way to get the navigational menu work with...

Well, the problem I have was not a terminal profile issue. The problem is regarding roaming domain user profile. I've checked the Resultant Set of Policy mmc and everything is working without any errors but it just doesn't delete the profile once the user log off the client computer.