Search results for query: *

I’m a big fan of F1 but did not know about F2. I love this site! Thanks again. Ron

PH, that works thanks. I was also trying to get a little education on the Sheet.CodeName that Skip mentioned. It may not apply in this situation but just for future use. I plan on checking into it. Ron

Skip thanks for sticking with me. My code will loop though all the sheets in the workbook starting from the sheet named Index to the last sheet, so I’m using the variable ShtIndex for the starting sheet of the loop. Ron

For my application would this be the correct statement? ShtIndex = Sheets("Index").CodeName Ron

Thanks Skip. Ron

I need a VBA statement(s) that will supply a variable with the sheet number of a specific sheet. For example the sheet number of the sheet named Index. Thanks Ron

That’s it, thanks John. Ron

I have, but could not apply it to my situation, although it could be my inexperience. Ron

I need assistance with coding cell validation. In a worksheet I want the user to enter a value in one of two cells, a value cannot be in both. Also a message box would be display indicating the error to the user. Thanks Ron

I am running this from outlook and do have the suggested references. Shifting priorities has moved this down my list so I have not worked on it since the first try. Subsequent posts will be in the VBA forum. Thanks again. Ron

Gerry, Thanks for the reply. It appears I need a little hand holding on this. I’m receiving the error message “object variable or with block variable not set” What am I doing wrong? What is an “accessible module” and if the user selected Word as the e-mail editor should the macro be in...

I need assistance creating a macro for outlook to add a specific string of text to the subject field of a message. The user would open a new message run the macro and the text would be entered in the subject field as well as the ability to run the macro on a forward or reply message. Thanks, Ron

Thanks Skip and Zack, I’m always amazed at the quick responses from this group. Zack, It works great thanks again. It should look familiar, it is mostly your code after you did an overhaul on mine a while back. All but using Integer of course. :-) The faq you reference is great stuff. Ron

Hello, The code below is executed from a workbook (WB1), the user selects a workbook (WB2), it loops through all sheets and copies values from specific cells in WB2 to WB1. The values from each sheet of WB2 will be entered in a new row on WB1, starting on row 3. I would like to alter the code to...

Zack Thanks for the last row example but it is not needed for my situation. It will always start on the third row and the data from each sheet will be on a row. A question about you code. What is the purpose of the statement: fileName = Right(fullName, Len(fullName) - InStrRev(fullName, "\"))...

Zack, It works great and the code looks better and more efficient, I assume. I have much to learn, thanks for helping with my learning process. I used the rCount variable for the starting row in the workbook the data is copied to (macro installed in) then it is incremented by one for each...

Thanks PH. That was the problem. Ron

I require some help with an error I receive when a macro executes. The purpose of the macro is to copy data from a workbook the user selects to the workbook the macro is in. It loops though the sheets and copies data from specific cells on each sheet to a row, one sheet to each row. The error...

Hello On a form I would like to display specific text boxes depending on a selection the user makes in a combo box on the same form. In the form load event the text boxes are visible = false. Would the code be similar to this: Private Sub ShowEntry() If Me.cboEntry.Text = "Comments" Then...

Thanks all for the replies. I will check out your suggestions and let you know. Ron