vba & code

Hi guys, I have the VBA code below to print the active worksheet to PDF in the Downloads folder. It prints to A4 sheet size on my computer BUT on my colleagues computer it prints it to Letter paper size. We want it to always print to A4 paper size, regardless of what computer it's used on or...

Hi guys, I need urgent help with this VBA code, I have got it searching a cell in each worksheet ("E1"). The issue I am having is that when it gets to a sheet where the cell "E1" does not have the cell text "NO", the code stops and it will not continue on to start searching the next worksheet...

Hi, Thanks much in advance for reading. It's really not an overly confusing concept, and I've tried to lay it out as simply as possible! I have some VBA code (not my own) that successfully returns combination sums between a defined range. A quick summary of what that even means, then my issue...

Hello everyone, I have the following code which that does not allow the user to paste values in a Data Validation List Column. My problem is that I have columns (without data validation) that have to stay protected, columns With Data Validation List have no locked option from format cell, but...

Hi, I have a question that I would like to ask you my good friends Is it possible to display a help text when the mouse pointer is placed on the button?

Good afternoon, For my work I have to send out multiple simmilar emails with a few minor changes per email towards cliënts. I am making (or trying) to make tool that prepares the emails for me as a whole (receiver, header, body). I would only have to click a hyperlink, check if everything is...

Hi all, Its been a while since I've posted anything so apologies if my upfront info is lacking (happy to add more if requested), but I'll try my best to describe the challenge I've got. Objective - Auto send an email with various info points from excel when a target date is reached in a...

Hi, How can I create a listbox in the userform? that when I was in any sheet, it would show me the information of the same sheet.

Hi, I will try to explain in different way. There are an dynamic array at B2:F10000 to read and a column Z2:Z37 with a series from 1 to 36 Read each number of each row and find how many rows are between the same value Example If value 10 is found in the row B4:F4 at D4 then on column AA5 will...

Hi there, I'm just trying to ammend my code so that it will save the file depending on the date i.e most of my file locations are saved as: 01.January 02.February 03.March Etc. currently my code saves it in/ or creates the folder 'March' but i just need to add the date number before the month...

Hello, From a old post I was trying to make a little adjustments, but I am not really good at it. this is where my question come from just in case you are intresting to give a hand VBA - Change a line in a code and this is the code I would like to adjust. Sub forum_Mrexcel() Dim...

Hi, I am using Excel 2013 I have applied the VBA formula but not return the results Below formula: =IF(ISNUMBER(I6),IF(VALUE(I6)=$L$6,MAX($H$6:$H$79),NA()),NA()) VBA: Dim MyRange As Range Set MyRange = Range("D5").Offset(1, 1 + 3).Resize(m + 1, 1) Range("D5").Offset(1, 1 + 6).Formula =...

I have a data at A2:AJ5300 and from A2:AJ5 have some unwanted lines and again on A65:AJ68, and A128:AJ131 etc meaning they have the same interval I tried this and do not work Sub montecarlo2012() Dim i As Long Application.ScreenUpdating = False For i = 2 To 5300 Step 60...

Apply page breakup as only page 1 to the dynamic data template and print it into PDF.

i have a list of missing and file names hyperlinks I want to create a button that, when clicked, reads the entire column and if it finds "missing," will collect those rows range and then will go to column A and read the first 2 letters and, based on that, will send an email to the...

Hey guys. I’m still learning how to code using VBA. I have been trying to devise a VBA code that will identify and color-code outliers in a database. I want the code to analyze the datasets per column and pick up outliers from each column. any help will be much appreciated

Good morning all. I am looking for a VBA expert to help with formulating a code for me. I have included screenshots with annotations on the functionality we require. Hoping someone is able to assist!! Thank you :)

I want to be able to hide/unhide rows (or group them, whichever works better) based on heading styles & heading order. I've tried using an .Autofilter technique but very quickly realised its dangers if people dont use subtotals as sums & major information was missed because of that method in the...

Hi everybody, I've tried a bunch of different codes I've found online for creating an audit log that tracks any changes within a workbook but either they do not work, or they create an endless loop that eventually crashes Excel. Can anyone help me with some code that will track any changes made...

Hello Again! I found an older thread with a similar question but I couldn't figure out how to apply it to my situation. On my [Sheet1] I have a drop down box setup that has 2 options (Inquiry/Update) what I would like to do is write a script that changes the workbook from read only to editable...