expected array

  1. M

    Active Directory Authentication

    Hi, I am trying to get this macro to work and getting nowhere fast. It involves a Private Sub UserForm_Click and a Public Function. The idea is, I have a userform with two text boxes, one for employee ID (always numbers and text box named "txtUser.Value") and the other for password (can be...
  2. H

    Compile Error : Expected Array

    Hey, I am trying to select all of the e-mail addresses in a table and display them without duplicates. The table name is "Signed Leases", the column name is "Email" and i am trying to place it in "text4". I receive an error message "Compile Error : Expected Array" at the "emails(count) =" line...
    • Healey33
    • Thread
    • access 2010 compile error email address expected array vba 7.0
    • Replies: 3
    • Forum: Microsoft Access
  3. B

    Expected Array

    Is there a way to copy a value from one cell to another, without using select? Same workbook, different worksheet. This line is causing an error "Expected array". lstrw is the lastrow and is an int. <code> For i = 0 To (lstrw) sheets("Output").Range("A1").Offset(i, 0).Value =...

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