line1

  1. N

    Code displaying as single line in email

    Hi, the following code displays as a single line If Range("B8").Value = "" Then Line1 = "Blank." Else Line1 = Range("B8").Value & " " & Range("C8").Value End If If Range("B9").Value = "" Then Line2 = "Blank." Else Line2 = Range("B9").Value & " " &...
  2. L

    Userform values do not equal

    I am making a duplicate entry notification. But the values will not equal for the notification msgbox to kick in. I have made this work before with another line of code by dim the value as double. But this will not work at all. Please take a look and tell me what you think. Dim Line1, Line2...
  3. M

    Excel 2007 Macro Copying Row from Main Sheet to Subsheets based on dropdown selection

    I'm not good at coding! Please help me. I have a start but it's not correct.:confused::confused: This is what I would like to do: On the main sheet I have a drop down menu in the first column, I can select "Prospect" "Team" or "Customer" The four spreadsheets I have are titled "Main"...

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