code

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Hi all, I currently have an email macro in VBA that looks like this (important parts only): Basically, I click on a macro and it sends out an email to the emails listed in certain cells. However, the message that the email depicts has been written in VBA with the .HTMLBody code. Does...

Hi all, Why do I get this error? When I run my code, it should send out an email. Thank you Kind regards, Jyggalag

I have a code that copies data from column C or E if there's no data on column C from all sheets on the workbook except the master sheet But this code is not completely mine, I asked a colleague help to make it for me What I know is that it also depends on column G Can someone please explain to...

Hello Power Users! I want to create a macro to export a specific range, in a specific workbook to a .txt file. Then title the .txt file with a name from a cell within the workbook. Data I want exported to notepad as text: 1.Range: B2:N34 ---> Sometimes this range will be larger, so I would...

Hi all, I have this file: How do I make a conditional formatting formula (or whatever it takes) so if the COLOR (not the text!), but the color in column C is red, then the color for the respective cell ("hello" and "this" in cell A1 and A3) will also turn red? Hope my question makes sense...

Hi all, I have this macro: Once I press the macro "Save file to folder", I get the error above, and debugging it leads me to this: I want to save my file as a PDF file in the path above. Any idea why it does not work and how I can fix it? Kind regards, Jyggalag