code

  1. R

    Macro to refresh workbook, clear sheet, refer to path and import columns

    Hi, In my worksheet, I would like to add a macro which does the following at once: 1) refresh the active workbook, 2) clear the contents of a specific worksheet, 3) import columns data from a closed workbook, 4) refer to the path of the closed workbook based on cell data in the open workbook...
  2. Jyggalag

    Write offset formula reference in VBA code

    Hi all, I have this formula: Essentially, when I fill in ANY data or make ANY changes to cell D2, i want the VBA to automatically update the current date/time in cell B1, so I can see the last time I made any update to cell D2. I can do xOffsetColumn = -2 But this will show the date in...
  3. Jyggalag

    Macro to save file as PDF saves full sheet

    Hi all, I have this overview at the moment: If I manually choose to save my file as a PDF, it works fine and I get just 1 page with the overview above. However, I have the following VBA code to save my file as a PDF: Option Explicit Sub SaveFileWithMacro() Dim Path As String Dim fn As...
  4. Jyggalag

    How do you make VBA code run automatically?

    Hi all, I am very new to coding in VBA and am trying to figure out how to make my code run automatically. I want to copy paste values from one cell to another, but nothing happens with my current code, any idea why? Thank you!
  5. Jyggalag

    Make VBA code that posts a cells formula as a value

    Hi all, I currently have the following setup: I have some numbers in column C and D, and I use a simple sum() formula in column B. However, I also want to be able to click on the cells in column B and see the value in the formula bar. But I want to keep the formulas in the meantime. What I...
  6. Jyggalag

    Have formula data appear as text, maybe VBA solution?

    Hi all! I currently have this setup, please note that I have hidden all the nonrelevant columns however: The formula I use is this (thank you @RoryA !) =IFERROR(INDEX(INDIRECT("'"&H504&"'!$U$3:$U$73"),MATCH(1...
  7. P

    Userform - "Add row below" button in VBA

    Hello everyone! I create Userform with this tutorial: Fully Automated Data Entry Userform - TheDataLabs Here is main code: Option Explicit Sub Reset() Dim iRow As Long iRow = [Counta(Database!A:A)] ' idetifying the last row With frmForm .txtNR.Value =...
  8. Jyggalag

    IndexMatch formula based on name of Excel Sheet

    Hi all, I currently have this setup: Formula in full: INDEX('Q4'!$V$3:$V$73,MATCH(1, ('Q4'!$B$3:$B$73=List!$D651)*('Q4'!$A$3:$A$73=List!$N651),0)) My sheet used to be simply called "Sheet1". However, I have renamed it "Q4" now. I want my formula to pull in data based on the value in column...
  9. T

    I am needing help making a macro that will save me time in my job

    I am looking to make a Macro in VBA that when run: creates a new sheet called "results" after the first sheet (to the right) on the original sheet search Colum B for if any of an array of words is present in a cell if it is to select the row and move it to the sheet called results delete the...
  10. B

    VBA to pop up a box and run the code accordingly

    Hi, Can someone help me with the below requirement. I have a code that is running fine but I want to place a message box in between to give a break to the code to do some manual updates. I am looking for code that pops up with a message asking to do manual updates in workbook and with option...
  11. S

    Convert JavaScript code to VBA

    Hello guys, i am a noob VBA user and im looking for a way to convert geographic coordinates (latitude and longitude) to UTM coordinates and vice-versa. In my searchs, i found a JavaScript code that allows me to do that, but i would like and have to do it on the excel, where i have the map of my...
  12. J

    Invoice and Quote template & Database

    Hi everyone, I posted a while ago about a workbook I am struggling with. Luckily didn't get any response, because the entire setup need to change. I need help please!! Currently estimate sheet is saved as Pdf and excel sheet in a folder. There was a clear contents function as well which I...
  13. B

    How do I get my userform VBA to copy and paste a specific row from a worksheet into another worksheet based on multiple complex conditions?

    I have rudimentary VBA experience, but I have a specific problem which I need VBA to solve. Here is my best attempt at explaining what I need VBA to do (with some context): Context on How the Spreadsheet Works I have a worksheet called 'Block Chain' which logs a large amount of data for a...
  14. Jyggalag

    Help me fix my VBA code (attachment error)

    Hi all, I have this code attached to a macro: Option Explicit Private Const FilePath As String = "R:\LXI_DLL\ZGJ_COMMON\FLD COMP FOLDER\12-FOLDER\TOPIC 2\ATTACHMENTS\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet...
  15. V

    Really need some help!

    Amateur to VBA and need some help in creating some automated graphs for work. I ideally need a macro command to delete any existing graph on the page and for a new graph to be created at the same time, for when data is updated within the table. I am comfortable in creating the command button...
  16. Jyggalag

    Change my VBA code so it sends pdf file instead of excel file

    Hi all, I currently have this VBA code: Option Explicit Private Const FilePath As String = "S:\COMPANY\FOLDER OF COMPANY\FOLDER 15\TEST FOLDER\Attachments\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim col As...
  17. Jyggalag

    Merge multiple email cells into one cell?

    Hi all, I currently have this setup: My VBA code is this ( credits to @RoryA :) ) Option Explicit Private Const FilePath As String = "\\UBSPROD.MSAD.UBS.NET\userdata\t684895\home\Documents\faq folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i...
  18. Jyggalag

    VBA email macro converts text into numbers?

    Hi all, I have this amazing email macro that @RoryA helped me build (big credits!). He created a nice loop for me that runs all subjects in an email meaning I can email as many email addresses as I want at a time. However, when I run it now, it converts my text into numbers for some reason...
  19. Jyggalag

    Object out of range VBA error?

    Hi all, I have a sheet with an email in cell A64. I am trying to create a macro that will send an email to this email, but when I click my macro I get this error: and debug highlights this: Did I not do it correctly? What do I need to fix? Thank you all! BR. Jyggalag
  20. Jyggalag

    Email macro

    Hi all, I currently have this code: Option Explicit Private Const FilePath As String = "\\COMPANY.MTJG.COMPANY.NET\userdata\t6853532895\home\Documents\TEST folder\" Sub send_email_complete() Dim OutApp As Object Dim OutMail As Object Dim i As Long Dim ws As Worksheet Dim...
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

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