vba & paste

  1. J

    VBA Copy/Paste:Copy area and Paste area are not the same size error.

    I am trying to Copy data from one document to another. I have a userform that allows for you to select which sheet you want to copy from and to. I also have to where it will paste into the next empty cell in the line. I have tried paste to a single cell reference and i have tried selecting the...
  2. K

    Help with VBA code - More to paste & pressing enter after a paste is complete

    Hi guys, I am running this code; Sub Dim lngMax As Long Dim lngcounter As Long Dim lngCalc As Long lngCalc = Application.Calculation Application.Calculation = xlCalculationManual With ActiveSheet lngMax = WorksheetFunction.Max(.Range("B" & .Rows.Count).End(xlUp).Row, .Range("C" &...
  3. A

    Copy and paste based on month and file name

    Hello everyone, I got helped before with a macro that copies amounts from 1 excel file to another excel file based on the names that are in the B column. It also makes the B column red if it didn't find anything to copy it to. Now I need to add a couple more things to this macro so I wanted to...
  4. M

    Copy Data from multiple sheets to one sheet based on condition

    Hi, I am a complete novice to vba and looking for help here. I need to copy data from a specific column 'Name' on multiple sheets in to one sheet based on criteria - The criteria is - Filter on column 'Contractor' as No find column which has column name containing current month Check the...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top