if-then-elseif

  1. C

    Help with simple routine

    I will never figure this stull out! Must be brain dead....Keep getting Else without If line 3 If Delete_Lst = Empty Then End If ElseIf Delete_Lst = vbNo Then Exit Sub ElseIf Delete_Lst = vbYes Then Delete_List Else ' End If Thanks in advance!
    • chobe
    • Thread
    • delete_lst elseif end excel vba if-then-elseif
    • Replies: 8
    • Forum: Excel Questions
  2. N

    Copying Data Based on Value in Column Using VBA

    Hello, I posted a thread earlier on this particular project I'm working on. Most issues have been solved and the program is sort of working. It's not encountering errors that stop the macro like before. The macro runs but i think the issue now is with the If-Then-ElseIf-Then-Else statement (see...
    • nryan
    • Thread
    • copying between documents if then statement if-then-elseif
    • Replies: 9
    • Forum: Excel Questions
  3. N

    And/Or operators in If-Then-ElseIf Statements Causing Mismatched Results

    Hello, It's been an arduous journey getting to where I am so far with my VBA code of cascading list boxes. I have two modules in my workbook: one for the cascading list boxes and one for outputting specific instructions based on what the user selects from the list boxes. The list boxes are...
    • nryan
    • Thread
    • and opertor and or if-then-elseif or operator
    • Replies: 1
    • Forum: Excel Questions
  4. K

    Need Help with this program to create unique workbook, save, mail and delete

    Hi I'm trying to modify the excel program to copy customised worksheet in new workbook, saving it as temp then mailing this workbook and then deleting it. I am having following difficulties: 1. If- else if statement not working 2. Showing object error Sub Send_sheet() Dim OutApp As...
    • ksghumaria
    • Thread
    • if-then-elseif multiple unique sheets outlook outlook and excel worksheet to workbook
    • Replies: 6
    • Forum: Excel Questions
  5. B

    Need help with If-Then-ElseIf in VBA

    Pretty new to VBA and I'm trying to clean up the following code so that if the value of cell C964 = 0, then simply hide all the rows in the given range and stop there. Currently, it hides all of the rows and then takes another 30 seconds performing the second If function. I'm hoping you VBA vets...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top