ranges areas copy

  1. K

    Issue with copying dynamic range

    Hello All, I'm trying to copy dynamic range without copy-paste sequence, where the position of last column is dynamic. To test the correctness of my code, I'm using fixed ranges now and this code works well: Sheets("Data").Range("A1:J1").Value =...
  2. K

    Faster copy paste function between sheets

    Hello Everyone, I am working on gathering some data on jobs that require very little assembly time and I am writing some script to automate that. In an effort to speed things up I am trying to resize the destination table to match the size of the data prior to copying. However, something is...
  3. F

    Insert two different ranges in a spreadsheet

    Morning everybody, I'm trying to crete a code for a specific action, but no idea on how to start. I have a folder with different contracts in excel files: contract1.xlsm, mickeymouse.xlsm, goofy.xlsm, contract2.xlsm, etc. The contracts have two different formats: one with a range of 40 rows and...
  4. C

    Making a table Macro More efficient

    Hey everyone I'm using this code to make a table for a graph to update by selection of data but I'm using a very inefficient method to do it. it works but I am wondering if there is a better way. Range("B22").Select ActiveCell.FormulaR1C1 = _ "=(COUNTIFS('Hidden graph...
  5. P

    Passing values of range with multiple areas from one sheet to another

    Hi, I've got two identical ranges on two different sheets (basically the second sheet gets created by copying the first). The ranges both have multiple areas, i.e. they look something like: $F$21:$I$23, $F$13:$F$16, $C$26:$C$28, $C$33, $F$26:$I$28, $C$37:$C$39, $C$44, $F$37:$I$39 Like I said...

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