row below

  1. V

    How to repeat vba code to use next row down

    Hello, I am new to vba coding so apologises if this is a very basic question! I am writing a macro that will generate a .zrxp file on which is written the following (from the Active Worksheet): Print #1 , "#REXCHANGE"; Range("A3").Value; "|*|RINVAL-777|*|" Print #1 ...
  2. S

    Insert Multiple Rows in loop

    Hello, I'm facing this problem of inserting rows in a loop. Your help are highly appreciated. Sub InsertMultipleRow() Dim i As Integer i = 6 Do While i < 100 Sheets("Sheet1").Rows("i:i").Insert Shift:=xlDown i = i + 6 Loop End Sub
  3. L

    If i <> "" then....Compare active row to next row only

    Hi All, I've come to the end part of a wee project and am a little stuck. I need to compare the data in two rows and highlight both if the entire rows, with the exception of coloumn "A" are duplicates. The code will activate if "A" has a value. That then becomes the source row, checking...

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