coding

Hi All, Im very new in VBA and trying to build my own coding by recording macros. However, I stacked in trying to find a way in preventing DUPLICATE DATA to be copied from one sheet file and paste in another sheet file. I have used remove duplicate in my coding (as per mentioned below) but im...

When running this macro to upload a file and pull in data everything works great during the debug until I F8 after the tmpVal code Not sure exactly what the problem might be but it looks like something in the esName is causing a problem? Currently this report is only pulling data for xlsx...

I have a few custom add-ins using various coding for specific work related tasks. At work, we password protect all our files. I am wondering if there is a specific code that I can add to my custom add-ins sheet that I would click and it would automatically do a Save As with a specified pw I set...

Good Day people, I was practicing some VBA questions and had hit a roadblock in the coding. The question was asking me to calculate distance between two points. My Goal was to clear the previously obtained value. However, the whole excel sheet got cleared. Here's the coding If (Range("A2") <>...

I am trying to get a macro to if necessary shut down the excel app where the macro itself is running from Currently at the end of the macro, I have the coding: Application.DisplayAlerts = False ActiveWorkbook.Close 10 End Sub The problem is that when this coding is reached, it does...

Hi guys, I'm having a little difficulty in tweaking some vba that I have got from a recorded macro. When I run it, I get the message 'Run-time error 1004, Method Range of Object_Global failed'. Once I click Debug, the VBA sheet opens. When I close it the macro has done what I wanted it to do...

Dear Sir I have a excel sheet which password protected. Though there are many macros in the file with vb coding. When user click the different buttons link with different coding, it run first to unlock sheet, run macro then lock the sheet. Now issue is every user can press ALT+F11 and can...

Good Afternoon, I have an input box that shows a veryhidden sheet. I'm trying to use Cell B23 on Developer sheet as the password (so the password can be easily changed). This code worked perfectly when the password was just typed in the coding itself but now trying to reference the developer...

Hello, I am stuck on creating code to find the max in a set of data and outputting the name of the cell. For Example if I have the following data set: <colgroup><col><col></colgroup><tbody> VIVIX 0.142966875 HLIEX 0.104074291 USNQX 0.144564163 HNASX 0.072884645 SCVIX 0.068055342 MMYLX...

Please Help I am running my payroll through excel and currently printing everything. I am looking to email everything instead. I want to be able to click a button and each employees paystub be emailed to them. Not sure if this is possible with a Macro or what coding to use. Thanks Greg

Hello- I have a "Sheet Creator" that runs and creates a sheet, formats it, inserts formulas, and then allows user input of a few pieces of data to create a fairly in-depth report. Anyway, near the end of the coding the sheet is hanging up on a formula, see the red section of coding below. I have...

So I'm stuck trying to figure a workaround to this- I've created this fantastic, dynamic workbook with awesome help from many of you. It seems to be working incredibly well, minus a few minute bugs. Anyway, because the users aren't VBA friendly at all (really not even formula friendly), I've...

Hi. I'm working on coding to automate filling details in users form. Before entering into user form I need select a form name from drop down list. Once selected IE page loads and wait time is around 3 secs. Then need to update details. Now I'm trying to automate this process by using VBA script...

Hello All, So i'm inputting statistical information for my fantasy football team to gain an edge on my defensive team since i couldn't snag one of the top defenses. ESPN has great statistical data that I've inputted into a workbook in excel. So now what i'm trying to do is organize the...

I have 17 worksheets (by manager) with one pivot table per worksheet filtered to data to suit each manager's needs. All the headings are the same on each pivot table. There must be a way to format all the pivot tables the same way at the same time or via a loop but I can't figure it out. I...

Hi all, Apologies, I'm new to this and new to coding so I will sound as though I'm clueless! Im creating a userform through VBA and I need to get some of the boxes I have created (label boxes) to add up the value that is in the text boxes (in some cases I need them to multiply). Does anyone...

I recorded a macro while creating pivot table fields and the coding is quite big. I am only showing a small portion of the coding. Is there a way to reduce this? With ActiveSheet.PivotTables("PivotTable1").PivotFields("Cost Center") .PivotItems("123744000").Visible = False...

TEXT(A3,"$0.00")&" per hour" Is it possible to color the "per hour" text RED without using VBA coding. Thank you for your help.

Please can someone help. I need VBA coding to automatically run coding in my sheet when ANY value is entered into Cell C21. If it blank, then I don't want the code attached to the worksheet to run at all Many thanks

Hi all, I am a VBA novice trying to get the syntax correct for auto-populating a form that I have where I need an OR condition, or something similar. In a regular workbook, this would be a matter of creating an array formula or adding two sumifs together. I'm not as sure how that works in the...