Recent content by ljCharlie

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