PPettit...I don't have all the answers, but I think you are on the right track in your last post. I created a workbook and added the relevant sheets, named ranges, etc and ran your macro but could not duplicate your problem UNTIL I added an ActiveX Command Button to initiate the macro. When I...
Oooops!...The above will give you a text string with the right name, but Excel won't interpret the text string as a range reference so it won't work in VLOOKUP.
Shelby,
Yes. While in the normal user interface, the sheets will be protected as always. Unlocked cells will be editable, lock cells will not.
I'm not sure what's going on with your issue of unlocked cells becoming locked when you protect the workbook. How are you unlocking the cells and...
Shelby...I notice several posts where worksheet protection is an issue for your macros. If you put this event procedure in your "ThisWorkbook" object, your macros can run without constantly having to protect and unprotect sheets. It also ensures that if you unprotect a worksheet and then...
Use VBA to "Find" the value in the range of the list, and then enter the data on the sheet you want. Put it within a Do...While loop with the condition that it continues to run continues to find instances of the desired value. The interface can be exactly as you want. When the "category" is...
Ooops...my post has part of an earlier version of my solution in it. Where it says, "CallCSVConversion," in the first paragraph, it should be "Workbook_Open event macro". This forum needs a feature for post editing!
upinflamezzz - If I understand correctly what you want, this should work as long as Excel is running and you have not closed the file where macro "CallCSVConversion" is located.
If you have a "personal.xls(b)" file in your xlstart folder, use the VBA editor put the following code in the...
As Skip pointed out, the solution depends a lot on what kind of differences you are looking for. If all you need to do is compare values, I'd make a third sheet and put the formula "=Sheet2!A1=Sheet3!A1" (note relative references) in every cell 729 x 98 cells. This will return a "TRUE" value...
Before reinstall, you might try closing Word, renaming your normal.dot file to something else, start Word again and see if you still have the problem. Word will create a new clean normal.dot file. If your macro is in the normal.dot file, you will have to put it in the new normal file before...
You might have to tweak this a little, but I think it does something close to what you want:
Sub Macro1()
With Selection
.InsertCaption Label:="Figure", TitleAutoText:="", Title:="", _
Position:=wdCaptionPositionBelow, ExcludeLabel:=0
.InsertCrossReference...
To answer my own question above, yes you can code an Outlook Contact List (distribution list) from within Excel VBA. Here is some code from MS to do it. I know this is not what the OP needs since he is using Lotus Notes, but it might be helpful for others using Outlook, or someone else...
Have any of the methods proposed here worked other than the one I mentioned? I'd like to know, because my conclusion that it can't be done with a single line of code was based on trying to solve the same problem trying the same ideas being suggested here until I wanted to pull out my hair...
The problem might not be at the code line where you are looking. "with" and no "end with", "if" with no "end if", other loops without "loop" or "next" can all cause the error you are getting. Without the proper closing statement for all such instances, VBA will give the error you are getting...
If Lotus Notes can't do what I said above, or if for other reasons you want to handle everything within VBA, you could create a Collection for the email addresses, populate the collection with the intended email addresses, and then write code to loop through the collection and send individually...
It sucks, but when I dealt with this problem in the past I found only two ways around the problem. One is you must code to send an email separately for each recipient. There is no way to name multiple recipients with a single line of code. The other way is to create what Outlook calls a...
On second thought, I think your original concept using "replace" was best, and you should skip any kind of looping altogether. The following code works, but you must name the ranges for the entire columns where the text is that you want to concatenate. For illustration purposes, I just used...
This is a hybrid between your original code using find and replace, and Skip's solution that loops through the range. This one loops too, but loops only through the cells that meet the criteria. In other words, if you have only 4 instances of "TEMP", it will loop only 4 times rather than 500...
Trey,
I'm glad it worked for you! And mahalo (thanks in Hawaiian) for letting me know. I enjoy playing with VBA, and it's gratifying to know I helped someone.
You might get more efficient yet if you considered Skip's questions about what are you trying to accomplish. I addressed your...
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.