rngtocopyfrom

  1. J

    vba code to insert named range at row chosen by user with input box which shifts cells down

    the code below inserts the named range cpa_2B at the row chosen by user with input box but it pastes over rows and I need the code to work as insert copied rows at the row selected by the user . thank you my code Sub copyCPA_2A() ' cpyCPA_2A Macro ' copies cpa_2B to selected destination Dim...
  2. D

    Copy & Paste specific range from sheet 1 to sheet 2 using InputBox to stipulate the column letter?

    Hi Folks, I wish to copy a defined range---G2:G12000 from sheet1 into D2:D12000 on sheet2. Sounds simple right? However, Sheet 1 arrives each day with an inconsistent column order: Column G (sheet1) is sometimes Column D, Column H or Column J etc. Problematically, the header name is not...

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