vba help

  1. B

    Trouble with Automating Naming Ranges (runtime error 424)

    Hi Guys, I am trying to use the below to run through values in Column A on a Sheet Named "Report" and Create these ranges in a Sheet called "Holidays_Requested" but everytime I it pops up with Object Required Runtime error 424. can anyone help or know of an alternative way of creating named...
  2. N

    Email from VBA with chart NEW

    Okay, so Ive read all the threads, and as you'll see in my (other peoples) code, spent some time on Ron's site as well. From that, I have 2 pieces of code working (3 including the function, lets call them C1 and C2), now I need help trying to mend them together. The first one (C1) gets data...
  3. A

    error message, probably by not defining things :/

    Hi, i have this code for converting a webpge into an excel document, then i can apply a bunch of autofilters on the copied data to manipulate it...i am fairly new to VBA, but using this project as a way to learn it... i have an issue with warning messages....the one at the moment is with when...
  4. S

    How to automatically identify contained values within text- VBA

    Hi, I am working with the following code in order to identify if the selected values are present in "Column B" of other worksheets within the same file. The issue I am trying to solve now is that it just colours the cells with the SAME value but it does not identify those with the contained...
  5. B

    VBA Help - to copy cell contents to used range and loop

    I need some VBA to copy the contents of cell "A3" and paste them in Range H7: "the last row used in column F" and then loop to the next worksheet. What I'm trying to accomplish: I'm turning individual reports (tabs) into a consolidated table (a summary tab), the department name is currently...
  6. B

    How To Set A New Variable

    Hi Guys, I hope you are all well and had a great holiday season. I was wondering if anyone can help me. I would like to know how to add a new variable to the code below that I am using for a holiday request form. That would say that If Team X is entered allow 2 people off and if Team Y Is...
  7. B

    VBA and IF Statements

    Hi Guys, I hope you are all well. I was just wondering if anyone could help. I have a holiday form that has Remaing Holidays in B12, Holidays Taken In B13 and requested in E21. What I was wondering if anyone knows how I would have a MSGBOX pop up If B13 EXCEEDS 25 Days or If B12 & E21...
  8. B

    Copy And Paste Depening On Criteria

    Hey, I was just wondering if anyone could help me with the below. I am trying to only Copy and Paste the rows that exceed "0", I have tried running this code but every time I do I get a run time error. could anyone help me please? an any improvements or suggestions would be greatly appreciated...
  9. B

    Copy & Paste when range meets criteria

    Hi Guys, I hope you are all well. I was just wondering if anyone would know how I can amend the below code so that it will only copy rows where the value in column D exceeds a Value of 0 any help would be greatly appreciated Many thanks jamie...
  10. S

    VBA ComboBox

    Hello, I am trying to create a Sign In/ Out log for work. So far I have the first half complete, where i can able to record all pertinent data name, trailer number, route, date and time in, but this is a two step process. now I have to figure out how I am going to input the "time Out". What i...
  11. B

    Copy & Past Large Amounts of Data

    Hi Guys, I was wondering if anyone can help. I am trying to use the below to compile an order of different products. ideally what should happen is that it copies Range B7:D69 to sheet 1 and then you can add another group of products to the next empty row. but what is happening at the moment is...
  12. B

    VBA to loop through a data input tab to populate contracts

    Hello everyone. I wanted to see if anyone could create some VBA or suggest a better way of doing process that we are currently doing manually. An example file is saved to the Dropbox link below. We hire temporary labor for different events and our departments submit a temporary hire...
  13. B

    WorkBook Open Error

    Hi Guys, I am using the below upon opening the workbook and have assigned both subs to the Workbook and not sheets. everytime i open the workbook i get a run time error 1004 saying that either the macros are disabled or the sub isnt available in this workbook. does anyone know how I could...
  14. B

    changing parts of a Text String using Macro's Or VB

    Hi Guys, I hope you are all well? I was just wondering if anyone can help me with the below question. I have 3 different customers each with their own label but the same information follows that label like below. Customer A red+550075110 red+660075110 red+550 red-550075110 red-660075110...
  15. B

    help with VBA & IF Statement

    hi Guys, I am currently using the below code for a holiday request form it takes the values on sheet 1: Employee Name : B7 Employee Number : B9 Team : B11 matches them against a reference on their team holiday sheet (determined on sheet1 B11) To Book Holiday in on dates determined in ...
  16. B

    Does anyone know how to Emails Ranges instead of Emailing Rows.

    Hi Guys, I hope you are all well today :) I have been using the below to fire off emails to customers. So their Account number appears in Column A & their email in Column B and it then sends off information row by row (C3:I3) to each customer. What I was wondering if anyone knows how I may...
  17. B

    VBA Transpose

    Hi Guys, I have been using the below code to transpose some order numbers Sub TansposeRange() Dim InRange As Range Dim OutRange As Range Dim i As Long Set InRange = Sheet1.Range("B3:B10002") Set OutRange = Sheet2.Range("B2") InRange.Worksheet.Activate InRange.Select...
  18. B

    VBA Copy And Paste

    Hi Guys, I was just wondering if anyone could help me with the below please. I am looking to have all the values from column A Sheet 1 copied to Sheet 2 a1:cm1 but is it possible that once copied that the macro would run through and name that range based on the value in the top cell a1:a5...
  19. B

    Setting Up Named Ranges Using VBA

    Hi Guys, I was just wondering if you could help me. I was wondering if it is possible to have VBA automatically(using a button) run through Column A setting up a named range for each individual value in column A on sheet 2 to a predetermined size (3x10) going along horizontally. So Sheet...
  20. B

    Copy & Paste Using Defined Name Ranges

    Hi Guys, I was just wondering if anyone knows how I can adjust the below code so it will Copy Cells B21 & C21 On sheet 1 To A Range Defined in B7 The range is on sheet 2 and is the users name Sub CopySheet1A1toSheet2NextCellInColumnA() Dim LastRowSheet2 As Long LastRowSheet2 =...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top