-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
end with
-
S
End a with Statement with for multiple objects
I'm wondering how to avoid having to type out 'End With' after each with statement. Can anyone help? Here's my code below: Private Sub UserForm_Initialize() 'Start Userform Centered inside Excel Screen (for dual monitors) Me.StartUpPosition = 0 Me.Left = Application.Left + (0.5 *...- scottyp10
- Thread
- end end with end with statements object statement
- Replies: 4
- Forum: Excel Questions
-
W
VBA With / End With problem for Highlighting Duplicates
Dear all, I have manipulated a code provided by another form user to highlight duplicate values in multiple sheets in a workbook. I have a Master sheet that contains all emails in column A, and I want to check 5 separate worksheets against this Master for duplicates. All the data for...- weepingpea
- Thread
- duplicates values end with vba & excel 2010
- Replies: 15
- Forum: Excel Questions
-
N
VBA Search - Block If Without End If
I have a list of zip codes and a worksheet (main page) with a search box. I have a function to check the zip code is valid (it works so I haven't pasted below). If it is valid but not in my list, a message appears to the right of the search box. If it is in the list I want it to paste into a...- npm26
- Thread
- block if without end if end with error search vba
- Replies: 1
- Forum: Excel Questions
