I have a button, when pressed it will ask the user to select the email
address from sheet 2, the problem i'm having is if I hide columns A, B and C
it comes up with a debug error but if the columns stay visable it works?

VB highlights the following:

Set EmailAddr = Application.InputBox("Select Email Addresses, Click on the
Email Worksheet" & vbCrLf & _
"Hold down Contrl Key to select multiple addresses", Type:=8)

Please help.