vba

  1. M

    Searching for values in a column

    I have a monthly sheet (Picture 1) that has 2 columns of concern, F & G. How to copy the values in column G to another workbook (Picture 2) in the column of the current month? Knowing that: 1- The order of names in the first sheet is different from month to another. 2- Sometimes there are no...
  2. C

    Hide / Unhide tables based on a list chosen

    Hi all, I’ve got a sheet with 4 tables on it. I have a cell in B2 with data validation set to a list on another sheet. I can currently hide or show the tables based on either columns or rows. As one table is shown the others are hidden. What I’m wandering is if it is possible to hide or...
  3. H

    How to stop VBA RTE when no data to copy

    I have a VBA macro which filters data and copies the results to another sheet. Everything was fine when the football seasons around the world were in full swing, but now with many having completed their interrupted seasons, there is less data. What happens is when there is NO data to transfer, I...
  4. S

    ActiveX cant create object

    I have created ClassLibrary1 DLL successfully using VSStudio2019. Also, added the .tlb as reference withing VBA. But when I set the object, I get "ActiveX cant create object". My DLL namespace is ClassLibrary1 and the class within the namespace is Class1 and function within is TestFunction()...
  5. C

    Auto Un hide Rows

    Hi All Im after some code that will always make sure that there are 10 rows available from the last row with data on and have the formulas and formatting still in. I have hidden rows and columns to make it look much neater, but if they need to enter more 10 tasks in, will need to unhide, copy...
  6. D

    VBA one cell returns date of last time another cell was edited

    Hello everybody, I currently have the following: Where column: I = quantity J = subtract any number entered from the quantity after which the number entered will be subtracted in column I and disappear in column J so you can enter a new one in the future J = add any number entered from the...
  7. B

    Formula R1C1

    Hi, Can anyone break this line of code down for me: Range("A" & Cells.Rows.Count).End(xlUp).Offset(1, 9).Select activecell.FormulaR1C1 = _...
  8. D

    VBA code not working anymore?

    Hello everybody, I am currently managing a stock tracking file, which is edited manually to a large extent. Currently, the four significant columns look like this: Here, column I is the actual quantity in stock. If my code was functioning, which it was as of yesterday (and I have made no...
  9. D

    Excel 2016 VBA Unprotect error for single user

    Good Evening, I’m wondering if someone could cast an eye over some VBA code I am using in a workbook. The workbook isn’t marked as shared and is protected, it is stored on a network drive so users can access it. Users all use the same version of Excel 2016 (RemoteApp hosted on a Remote...
  10. J

    Referencing code name of second workbook vba

    Morning All I have two workbooks. The active workbook does some calculations/ has some user input, and then a macro is used to move certain entries to a second workbook. Both workbooks are set up using code names as somebody will inevitably change the worksheet name at some point (!) but...
  11. D

    Formula in Excel to display email message with CC & email receiver

    Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...
  12. U

    VBA FormulaArray Syntax/AutoFill/Set Ranges

    Hi all I am trying to do a few things here with VBA: Here's the source Worksheet named MoCMatrix ABCDEFGHIJKLMNOPQRSTUVW1HELPER ROW > Structural Integrity-MoCStructural Integrity-Substantiation DocumentStructural Integrity-StatementFlammability & Smoke-MoCFlammability & Smoke-Substantiation...
  13. D

    Send/display email through Excel in Outlook

    Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...
  14. G

    VBA to collect data from different files to one file on different tabs(worksheets)

    Hi All, I am trying to get a vba code to copy information from different files to one destination file but on different worksheets on the destination file. The destination file is called "Master data file ". The master file has worksheets named ""Sheet1","Project1" , "Project2"...
  15. L

    VBA to update one sheet from data stored in another workbook

    Hello there! How are you? I hope you can help me. I'm new in VBA and I have an issue I can't resolve. I'll try to explain what I need. I have Workbook A and Workbook B. Data in Workbook A is updated by clicking a button. It takes information from another Workbook B that is generated by an...
  16. A

    Create Worksheet for each new CC added in a list

    Hello, I have the following code which copies a master worksheet with formulas and renames it with the company code and cost center. Everything is happening in the same file, which is a database with cost centers and companies to be charged out. Each time a new cost center is added to the list...
  17. D

    We found a problem with some content in "File name". Excel annoying message

    Hello everybody, Whenever I open my excel sheet I get the following message: "We found a problem with some content in "File name xxx". Do you want us to try to recover as much as we can? If you trust the source of this workbook, click yes" It is super annoying. It started happening after I...
  18. V

    Listbox to insert data to selected line

    Hi currently I have a userform with a listbox that displays the data I've selected in textboxes but whatever code I try to insert the new data to either the listbox or cells of the highlighted line in the list box I get error "70" listbox does not have permission.
  19. D

    Refresh pivot table and report in protected sheets

    I have sheet-a, it contains pivots only, only allows select locked/unlocked/autofilter, and sheet-b, it contains pivot chart, only allows select locked/unlocked/use pivot table & report, sheet-c contains both pivot and report, only allows select locked/unlocked/use pivot table & report, some...
  20. M

    AddCustomlist failed error

    Hi, What is preventing the below custom sort from running? Dim keyRange As Variant Dim sortNum As Long Dim RowsSorted As Long: RowsSorted = Worksheets("[tab]").Cells(Worksheets("[tab]").Rows.Count, 5).End(xlUp).Row Worksheets("[tab]").Range("A2:A" & RowsSorted).NumberFormat = "@" keyRange =...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top