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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top