hi PHV,
Thanks a lot for your reply. My English is not good enough and always feel difficult to explain clearly what I thought.
Actually I don't want to create a new mail to a known e-mail address by clicking the hyperlink. What I want to do is when I click the hyperlink, the specific existed...
Hi everyone,
Recently I have a idea derived from google desktop which could search a lot of outlook e-mails and there is a link in the search result page that direct me to open the e-mail from outlook. Could I make the similar hyperlink in a cell of an excel worksheet too? Does anyone have the...
Hi Tony,
Thanks a lot for your warm response which let me make sure that someone do read my question but just can't help on it yet. And thanks for your star. [peace]
Regards,
Hoki
I guess this question is too easy for all friends here to answer, so I didn't get a response.
After more research and I think windows API could help, though I don't learn any of them. Finally I found a sample which I could apply after a little modification, and now it works.
For people who might...
update my experiment situation:
I found the method of "appactivate" and saw many people discussing it. Looks like it should be able to solve my problem.
But I do a little experiment as below:
1. open a new workbook,
2. and add a userform called UserForm1.
3. add a module and edit...
Hi, everyone,
I've been trying making an Excel VBA procedure which uses ontime method to run itself periodically. This procedure will check the data and pop-up a remind window (UserForm) showing all items are due.
When this procedure is executing, I may be under the environment of IE or Outlook...
Dear all,
First of all, I would like to thanks for Geoff's kindly help verifying the real problem I encountered. So I give him a star.
It looks that UsedRange is not reliable, and this is echoed by the link that Loomah provided. And thank Loomah that just find the exact answer from other site...
Dear Geoff,
>How are you putting a text string in there (code or manual)
I manually input a string in a cell at row 65536 (to emulate common user's behavior)
>and how are you clearing it ??
Again, I manually press "Delete" button while the ActiveCell is at that cell I just input the...
Dear Geoff,
It still seems not work for me. In fact, I've tried this sub by press F8 (step by step). I've tried to run Dale's code only, the Msgbox shows "65536 rows 4 columns", and even after these codes, the selection of usedrange still contains cells in row 65536 where the content...
Dear Geoff,
It seems not work for me[sad]. Is that because I missed the correct method to use the source code?
I try to type some strings in several cells of a worksheet. And then try to fill in a string in a cell at row 65536.
When I clear the content of row 65536. I run below sub:
Sub...
Dear Geoff,
Thanks a lot for your sharing. I believe that's what I've been looking for and I will have a try later but just want to show my appreciation to you first.
Best Regards,
Hoki
I know that excel has the properties of "CurrentRegion" and "UsedRange". But I feel that both can't really detect the range used. For example, CurrentRegion could only confine the region that isolated by blank cells around it.
That means one worksheet could has several...
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.