vba

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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 /...
  6. 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"...
  7. 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...
  8. 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...
  9. 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...
  10. 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.
  11. 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...
  12. 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 =...
  13. O

    VBA text to columns for a document of inconsistent strings

    I need a macro to help with text to columns for a document of inconsistent strings. Ex strings 123456 *toName 4 100.00 234567 fromName 2 12.000 2 Q12:toName:fromName:1 165.0 183.7 26.0 185.5 112.5 234567 *toName2 2 17.000 345678...
  14. F

    Fill blank cells in all named ranges by copying first column in a named range if the first column is not blank

    Dears, I am having a data set with multiple named ranges with each range having one row and 14 columns. Column 'D' of each named range is always filled, where the copy will be required, ranges with blank 'D' column can be ignored. What I want to do is to loop through each named range and...
  15. D

    Have one cell check whenever data in another cell changes for entire column

    Hello everybody, I am currently managing a database full of stock quantities, here: Is there any way (I imagine some VBA coding) in which I can create a column 3 rows to the right of this one (row L in this case), where every single cell in row L would count the last time (in date, so for...
  16. D

    Run-time error "53": File not found

    Hello everybody, I am currently having a problem with one of my files. I have made an order form where people can order goods from. They download my excel sheet and click on a submit macro which sends out the excel sheet in a PDF file through email. This works perfectly fine when I do it...
  17. P

    Download File from SharePoint library to desktop using VBA.

    Hello All, I have been trying to Download File from SharePoint library to desktop using VBA but unable to do so. I need help with it.
  18. I

    How to convert numbers to words in Excel with Hyphen - Minus Values

    Hello Everyone Good day, I'm using below VBA code for last 1 years and today I discovered the small error in VBA code . When I write minus -10,000 it shows on "Only Hundred Ten Thousand" When I write positive 10,000 it shows on "Only Ten Thousand" works fine Can someone please correct my VBA...
  19. I

    VBA how to 'Save As' ?

    Hoping I can get some help with this, quite new to VBA and loving what it can do ! I have this bit of code below which will save 2 sheets into 1 PDF: Sub CompileReport() Dim mySheets As Variant, sh Dim filename As Variant mySheets = Array("Print User", "Print...
  20. I

    Really stuck ! Print to PDF won't format properly

    Hi Everyone, Firstly, very new to VBA so bare with me. I am trying to print 2 worksheets to the 1 PDF, formatted to all columns fit into 1 page but I just can't get it to work. Here is my code, first it generates the sheets I need then does some formatting, it then calls next module to print...

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