excel vba copy paste cells without user noticing

excel vba copy cell value and paste to another cell
excel vba copy paste range another worksheet
excel vba copy range to another workbook
vba copy paste values
range.copy vba
excel vba copy destination values only
excel vba select range with variable number of rows
excel macro to copy and paste from one worksheet to another

I have a macro which copies and pastes a lot of cells in a different worksheet. This works fine, my question is:

Is it possible to make the whole macro run in the background?

As the macro will be used by inexperienced excel-users, I dont want them to see the macro jumping around and copying loads of data which makes the screen go crazy.

Thanks for your answers in advance!


Use application.screenupdating = false at the start of the macro

then Application.Screenupdating = true at the end, and the screen won't jump around.

Also worth adding Msgbox("The macro has finished!") or something similar at the end so that they know it has done its thing.

Excel VBA Copy Paste: The Complete Tutorial And 8 Examples, Excel VBA Copy Paste: The Complete Tutorial For Copying And Pasting Cells With You may have noticed, however, that the Copy button isn't just a simple button. your purposes without copying to the Clipboard, you should simply use the  I am writing a method that can take the Target and paste the cell exactly to another cell. VBA How to copy the content of a cell without .Select Excel (.XLS


I'm guessing your 'macro' looks like this.

Sub Macro1()
    Sheets("Sheet1").Select
    ActiveWindow.SmallScroll Down:=4
    Range("J16").Select
    Selection.Copy
    Sheets("Sheet2").Select
    ActiveWindow.SmallScroll Down:=5
    ActiveWindow.SmallScroll ToRight:=2
    Range("I19").Select
    Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False
    Sheets("Sheet1").Select
    ActiveWindow.SmallScroll Down:=-72
    Range("A1").Select
End Sub

It would be better if written like this.

Option Explicit

Sub Macro1()
    With Worksheets("Sheet2")
        .Range("I19") = Worksheets("sheet1").Range("J16").Value
    End With
End Sub

Learn more with How to avoid using Select in Excel VBA..

Working with Cells and Ranges in Excel VBA (Select, Copy, Move , To work with cells and ranges in Excel using VBA, you don't need to select it. how we can use the same concepts to copy and paste cells in Excel (using VBA). As you might have already noticed, the above code copies the cell without  I have a cell in a worksheet named A and I have to copy it then paste it to Range(Cells(23, 60), cells(23, 78)) of worksheet called B. How should I do ? I thought about using dynamic cell references like : copyrange = Range(Cells(696, 60), Cells(696, 60)) .


How do I copy a worksheet without creating local , For the sake of completeness, here is my answer from your follow-up question that ended up working: You should be able to select all of the cells in the original​  Now, these examples are not very useful, but you will see later in this tutorial how we can use the same concepts to copy and paste cells in Excel (using VBA). Just as we select a cell, we can also select a range. In case of a range, it could be a fixed size range or a variable size range.


VBA / Macro Copy & Paste errors, I have a spreadsheet workbook which I use for business. As Excel has no easy way to mass-delete lots of conditional formatting Now, I try copying text (a single word) from notepad into an cell on a sheet of the problem workbook: (I'​ve just noticed that if you open a "new" copy of excel, the script does  How to Avoid the Select Method in VBA & Why another common command to copy/paste values, format a cell, insert formulas, etc. Excel VBA instructor and early


VBA How to copy paste from one worksheet to another without , r/excel: Discuss and answer questions about Microsoft Office Excel. VBA How to copy paste from one worksheet to another without knowing what the cell range will be? I only want a range of cells from that particular sheet. I'd use one macro to specify the different sheets, and another to do the repetitive copy action. Re: Copy and paste using .range(cells(1,1), cells(1,7)) Thank you I will give it a try. my solution is less elegant. I found that if I changed sheets to the copy from sheet it worked fine. I just don't like the fact I had to do it. It is not logical to me that it would fail since I was defining what sheet I was trying to copy from.


Excel VBA Copy Range to Another Sheet with Formatting , We copy entire columns of the required range and paste in another sheet. This approach is usefull when there is no other data in both the sheets. Copy and Paste Over Existing Data without clearing the sheet I'm using the below macro to import data from a closed workbook. The problem I'm having is that it only works if I clear the cells on the sheet first.