lcopytorow

  1. S

    Need help with Macro to copy a range

    Hey All! I'm in need of help on this macro. What I have it doing is searching the sheet for certain things and copying them over to another sheet. However it copies the entire row (which isn't needed) and I was hoping I could just set it to copy the first 3 columns of that row. The macro is...
  2. T

    How to Copy Certain Cells From One Page to Another Based on a Key Word?

    Hi all I have "borrowed" a VBA from the internet and I am trying to alter it to make it do what I need. What I want it to do is look on page "LX" in column A for the word "current" and if it finds it then copy certain cells from that row to the sheet "In Service" I made some changes and I...
  3. S

    Copy Paste a range instead of row

    Hi Everyone I have a macro i have been using for years no problem. But i would like change it to copy a range of cells instead of whole row. I have been tying to change it to no success Please help! Dim LSearchRow As Integer Dim LCopyToRow As Integer On Error GoTo Err_Execute...
    • st1
    • Thread
    • copy lcopytorow load.select lsearchrow row
    • Replies: 2
    • Forum: Excel Questions
  4. D

    VBA search all matching values in column copy specific ranges to different sheet

    After looking around, I distilled this code down https://www.techonthenet.com/excel/macros/search_for_string.php that partially achieves what I need. Most of the examples I've found usually copy entire rows along with the example I've submitted. I only need 2 offset values (columns C:D) copied...
    • devofish
    • Thread
    • copy cstrlsearchrow.value err_execute lcopytorow lsearchrow
    • Replies: 3
    • Forum: Excel Questions

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