introw

  1. azizrasul

    WorksheetFunction.VLookup not working

    I get Run-time error '1004': Unable to get the VLookup property of the WorksheetFunction class on the VLookup line. Column H is formatted as date. Dim intRow As Integer Dim dteMax As Date intRow = Worksheets("Customer Product Export").Range("L" & Rows.Count).End(xlUp).Row...
  2. S

    Insert copied rows multiple times

    I have a range copied and I want to past that range several times in each sheet (inserting a 9 row range) and moving the current contents down with each paste. My loop works once. Then it will just insert a single row, as though it has forgotten the copied range. How do I get it to insert the...
  3. X

    VBA- search sheet name from range.. then copy from range sheet, paste transpose into that sheetname

    Hello, I need some expert help please .... I have below Macro code.. It only looks for CDH.. I want it to find sheetname from range r2:r19 in sheet 'instructions' .. Copy that active cell row T:AE and transpose pastevalue into found sheet (CDH in this case) in range 'D4:D15' Sub...
  4. A

    VBA question - Trying to write information into a new row in a different sheet but it keeps overwriting old information

    Hello all! Title says it all but basically I am trying to create a worksheet in which everytime I input information into Sheet 1, it is copied into Sheet 2. I want to have each entry in succession on Sheet 2 such that my first entry would be on Row 2, second on Row 3, third on Row 4, etc...

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