edit code

Hi. I found this on contextures and it creates monthly workbook with separate daily blank sheets and date as the tabname. How do I change it to copy a template sheet instead of creating blank sheets? Also, to add the code to change merged cell of A2:J2 to the date created each day as "DD MMM...

Hi, so I have this JSON code that pulls metrics from a work website. However, it pulls different numbers than I am looking for. There are metrics on the web page in 60 minute increments and 15 minute increments. I need the 15 ones but I cannot figure out how to tweak this code to do it. Here is...

This module compares columns "S"&"Q" and "Z"&"I" against each other. I am not sure why it works like this; however, this code produces the enrll_Mismatch_Msg only when they match at the moment. I managed to write a short snippet which fixes this; however, it seems to be unreliable. I'm looking...

Hi all. I have a macro I wrote in vba (2010) to update the years in a template and change the sheet name. The code is based on the individual sheets original name. Is there a way or a line anyone can think of that will change the code to match the new sheet name after the macro has done it's...

Current, what i'm doing is i want Cell A6 in Worksheet("Compensation") to be show up looking like "less Items # 1,5,4,6." Those numbers actually correspond to cell values in Column A in another worksheet known as "Cap. Rec." when Column E holds value R. What I actually got was the formula only...

Hello, As is frequently reccommended, I use the macro recorder as a starting place to try and figure out new thingsI'm trying to do. Has or could anyone has come up with a small utitlity to clean what I'll call 'junk code' from macro recorder code. The most common example in my experience is...

HI i need edit code automatically send email when AC cell value changes to yes Sub Mail_Sheet_Outlook_Body() ' Don't forget to copy the function RangetoHTML in the module. ' Working in Office 2000-2010 Dim rng As Range Dim OutApp As Object Dim OutMail As Object With Application .EnableEvents...

Hi, Happy Friday:biggrin: I think i need some help here. I have this code which I dont know how to make it work.Hilighted region is where i'm getting error.. Please modify whi Sub DT_try() d1 = Range("A" & Rows.Count).End(xlUp).Value d2 = Date & " " & Time 'd3 = d2-d1 'if d3 <...