code check

  1. mikecox39

    Textbook code fails to work

    I copied this code from Excel VBA: by Nein Smith and I can't get it to work. The data is a mixed list of number from 1-10 in Column A, color line works but the text line does not I know there should be a Then in this macro to the author was just trying to show how Conditional logic works, at a...
  2. S

    Double Click Problem with Code

    I am using an Excel file to store primarily demographic data. I have two pieces of code imbedded in this workbook that allows me to use a Combobox to select demographic data and change to an abbreviation. For example Green -> GR, Purple ->PUR. The code has affected my ability to double click...
  3. A

    Code Help!!

    Anyone know why this line of code is failing? Private Sub GenerateRedsNights_Click() Sheets("Red Alerts").Range("A5:M500").ClearContents If Sheets("General Areas Sauce").Cells("D20:D59").Value = "R" Then Sheets("General Areas Sauce").Cells("G20:G59").cellcopy Destination:=Sheets("Red...
  4. E

    mass email i keep getting errors can some1 HELP ?? ? ? CLICK HERE !!

    i keep getting an error can some1 look at this and help me fix this code? or help me with the notes in this code Sub sendemail(what_address As String, subject_line As String, mail_body As String) Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application")...
  5. C

    Macro: Pivot table from another Tab

    I am trying to create a pivot table, I would like the table on a diffrent tab then that of the data. Below is the code I am using, it is running all the way through not erroring out but my screen comes up as blank. Can some one tell me why my code is not pulling in the correct data or why the...
  6. K

    Problem with my code! Please help me fix!

    Hi, Not sure why this is happening. I have buttons located on column N and Column X. They show and hide Columns O-Q and Y-AG, respectively. I thine have code in the sheet to expand columns when activated so that the user can clearly read the choices in the data validation list. However, now...
  7. pedie

    Please check my VBA CODE; I have to be sure I'm doing it correct. Thanks for helping!

    Hi Everyone! My code is working perfect i guess for now but I have to make sure things are placed accordingly like error handling etc....as i dont want problem to occur latter. Thanks again! Pedie;) Sub try12() Application.ScreenUpdating = False Dim wb As Workbook, MyFile As String Dim sh...
  8. pedie

    Please check my code & tell me where i'm doing it wrong. Cant make it work. Small code. Thanks

    I dont know why my code does not leave a row before pasting.... please check where is it wrong. Thanks ped;) sub try1() Selection.Copy Sheets("Data").Select Range("b2").Select Do Until ActiveCell.Value = "" ' i have place (1,0) to leave 1 row before...

Watch MrExcel Video

This Week's Hot Topics

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
Top