vba copy

  1. R

    VBA copy sequence minus one and paste, loop?

    Hi, I am trying to figure out on how to copy a 'range'/'list' in column A to the next column B and then copy the same range/list A minus one selection to the end of column B (after the first copy) and so on , until the range in A is finished/ has reached its end. example Col A 15901 14901...
  2. J

    Copying specific data to another sheet based on cell value

    Hi guys, What I am looking to do is copy data from one sheet to another, however I only want it to copy columns A and B based on the cell value of Column E in each row So far I have the following code which is able to copy the data, but currently pastes it on every column on the worksheet and...
  3. L

    Copying listrow throws an error (copy method of range class failed) why?

    Hi all, I have the following code: If Not Intersect(Selection, ActiveSheet.ListObjects(1).DataBodyRange) Is Nothing Then<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit; line-height: 12px;"> Dim CopyRownr As Long CopyRownr = ActiveCell.Row -...
  4. dannyok90

    The Classic 'Add New Row Button' Macro

    Hi Guys, I'm aware there is tons of information on the net about this and I'm sort of biting the bullet asking such a generic question. I have a spreadsheet which is a template at the beginning of its life so there is literally no data in there what so ever. I'm wondering if someone could help...
  5. G

    VBA copy data to another file

    Hi there, I am trying to copy some data a file called "Excel Macro.xlsm" to a file called "BCH.xlsx" but cnt seem to manage it. The original file "Excel Macro.xlsm" contains 2 sheets: master and BCH. I have placed a button in the 'master' sheet which should extract cells A1:E20 from the BCH...
  6. L

    VBA worksheet copy problem

    hi, I was hoping someone might be able to help shed some light on the following. When I execute the following macro a new workbook (containing a single worksheet). However, I've noticed that when I execute the macro the name of the new workbook (containing a single worksheet) that appears...

Watch MrExcel Video

This Week's Hot Topics

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
Top