excel 2010 macro

I am trying to create a macro to copy values from multiple row cells and paste those values into multiple row cells on another tab. THEN: If the user changes any of the values that were copied and pasted previously (from the first tab) and the macro is run again, the data is again copied but...

Hi, Im yet to go on a VBA course, however Ive managed to find a VBA code to pdf a report in Excel 2010 and automatically send it via email. However, now the report is a bit more dynamic - the pivot table is linked from Access and Im using a 'Slicer' to individualise each report that is to be...

I am using Excel 2010. I have created a macro in my PERSONAL.xlsb file that I am able to run if I go to Developer - Macros - Choose the macro name - Click run. However, if I add the macro to the quick access toolbar or the ribbon, nothing happens. I don't receive any error messages, the...

I have a table where I need to find the elements present in different samples. For every sample, the no of iterations is a variable - I can have two rows of sample 1 and 3 rows of sample2 or 5 rows of sample4. the number of columns which are the elements can also be different. I have considered...

Hi, I am comparing some data on types of differences: additions and deletions. I've used some code from a previous thread to compare two strings and find difference; and simply switched the WORDDIF arguments accordingly. =WORDDIF(A1,B1) Code: However, I have come to some obstacles. 1...

So I needed to create a random range and then calculate the average of that range. Once the average is calculated I need to: A) Calculate how many numbers are greater than the average, highlight all numbers greater than the average and place the amount of numbers that are greater than the...

In the two subroutines at the bottom of this post I am able to save a .gif from a workbook to a normal network folder but when I attempt to save to a SharePoint folder the code error out. These two lines of code... Save_Object_As_Picture Worksheets("CA Info").Range("C3:I142")...

I have tried a few different ways of checking now and none have worked so far. Here is the most recent version which did not work: Public Function MakeFolder(Directory As String, FolderName As String) Dim TestDir As String TestDir = Dir(Directory + "/" + FolderName)...

I have been using this macro now for years and for some reason today is starting to throw this error. The macro takes a workbook and creates a new workbook for each worksheet, runs the macro "Customer Invoice" to format the file and then saves the file as the name of the worksheet plus the...

Hi, I am trying to modify this VBA I found on the forum that is several years old. Sub Test() Const LinkName As String = "Book1.xlsx" Dim CalcMode Dim ws As Worksheet Dim WorkRange As Range Dim Cell As Range Dim FormulaParts As Variant Dim i As Integer Dim...

Hi All, I'm a newbie to the forum and have limited a understanding of Excel. Currently using excel 2010. My question is around totalling columns across multiple workbooks. Let me break it down more sizeable and understandable format. Data source is in workbooks with names such as ( 2015...

The macro is to change all formulas into values: When I run it, I get the error message if I type as it is in book, that is, with "with ActiveSheet" on same line. However, if I have it on separate line, it works. Why is that? Compile Error Syntax Error with the Dim line highlighted. Macro...