application.cutcopymode

Hi all - so I'm trying to see if there's a shorter/better version of what I'm doing? I have a macro created that I look up a value from one workbook to another and copy everything that's from the 2nd workbook to the first workbook. But I want to know if there's a way to put this in loop till the...

I have below code , but its not working can any one help me. Sub UpdateLinks() Dim wbSource As Workbook Dim wbDestination As Workbook Dim wbSource1 As Workbook Dim wbDestination1 As Workbook Dim wbSource2 As Workbook Dim wbDestination2 As Workbook Dim wbSource3 As Workbook Dim wbDestination3 As...

Hello everyone, I have recorded a macro and it works fine. I have 18 sheets that are numbered 1 through to 18. I would like this macro to loop through each sheet from 1 to 18 as I will need to extract data from each sheet about 4 times (I can change the range(D25) each time I run it. Thank you...

I am having a problem running a macro I originally created in one workook in other workbooks. The code is a simple copy paste, remove duplicates, and sort alphabetically. However, I want to be able to run it without the original workbook open. I put it in VBA Project (PERSONAL.XLSB), but when I...

If recorded control shifting down on C1 VBA creates a defined cell range instead of a dynamic one Range("C1:C13"), CopyToRange:=Range("D1"), Unique:=False So I tried to insert VBA I thought would correct the issue because it works normally but got this error Wrong number of arguments or invalid...

Good day.. Need help - Newbie in VBA coding. have below code: Columns("Z:Z").Select Selection.End(xlDown).Select ActiveCell.Offset(1, 0).Range("A1").Select ActiveCell.FormulaR1C1 = "=TODAY()" 'Selection.Copy Range("x3").Select Selection.End(xlDown).Select...

Anyone ever see these kinds of issues? My code executes just fine and quickly in excel 2010 but errors out on one line in Excel 2016? *Please forgive the archaic selects all over this code, I didn't write it but I have already re-written but the error still occurs on the same line...

Apologies in advance for the basic question. I was slowly becoming a whizz at VBA a decade ago, but I'm picking it back up and need a few pointers I'm making a macro to take info from sheet to another, and then to fill forumula that I've entered into the sheet already (that'll be a separate...

Hi all, From reading through this site, I've written a macro to copy an input from a list, paste it into a model that calculates based on data pulled in from an external source, and then paste specials the results back to the list. However-- when I run it, the macro runs faster than excel can...

Dear Experts, Not able to add an attachment. Working on a code that can fetch file name from local drive and rename it. Have break inrto 3 codes. 1. Fetching file name 2. Getting the new file name 3. Renaming in local drive. Macro 1 & 3 are working fine but facing issues with macro 2. I...

Hi all, I've got a large Excel document with about 16 worksheets. Alot of the cells have a colon at the end of the strng, but not all. I need to remove all of the colons sp that my Index Match formulas will work. I've recorded quide a detailed Macro and added the code in to remove the colons as...

Hello. I created a vba for my coworkers in Excel 2016. When users in 2013 run the code, they keep getting a runtime 5 error. Any suggestions? I tried various solutions on this board but can't seem to get it to work. Is it the "DefaultVersion:=6" that is creating the problem...

Hi there, i am trying and trying but unable to get the simple vba code to work correctly for the below. I wanted to: cut from active cell and paste that value only into offset cell (1,-1) unbold the text Can someone please help? Thanks in advance! Sub PreCR_FindingCat_creation_cut_paste()...

when i run the macro i get Unable to set the formular array property of the range class Columns("B:B").Select Selection.Copy Columns("M:M").Select Selection.Insert Shift:=xlToRight Application.CutCopyMode = False Selection.Copy Columns("N:N").Select Selection.Insert...

Hi All... new to the forum and pretty new to VBA.. about a week new and looking for some support. I am writing a script to do table comparisons and am stuck on a loop issue. for arguments sake say there are 2 folders with different names and inside the folders there are a number of csv files...

After Selection.Find.. the whole column in question remains selected/highlit. I don't really want to leave it like that but so far these suggestions don't seem to work in my version 2007 SendKeys"{ESC}" Application.CutCopyMode = False Any other things I could try (apart from selecting...

Hi again all, I currently have 4 seperate reports going into 1 main report to give me information i need, i have started doing a macro but this once error shows and im not sure what i can do to solve it. its quite a big sheet.... the debug is highlighted in red. Sub Macro4() ' ' Macro4...

Hi All, I'm trying to run the below macro (recorded) however it stops before it gets to "Rows("1:8").Select" It also paste special values columns AF & AG which I don't want it to do. I've been trying for hours and almost given up hope! Any help is greatly appreciated. Thanks, Wes...

Looking for VBA help to complete this task... Goal is to copy and past from cells into a templet, print a defined area with this information then repeat until there is a blank cell. The macro for doing 1 row of information looks like this... How do I get the macro to loop until there is...

I have the following code in my worksheet (forgive the crude coding). It works just fine on my PC but when I send the worksheet to my client and he runs it on a Mac, it crashes Excel. The crash report is 48 pages long and includes the following error message: "Error Signature: Exception...