-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
row below
-
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 ...- Virkis
- Thread
- macro repeat code row below vba write to file
- Replies: 1
- Forum: Excel Questions
-
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- sirmacademy
- Thread
- integer loop loop and insert row below rows
- Replies: 2
- Forum: Excel Questions
-
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...- Lovelylou79
- Thread
- code highlight duplicates row row below rows
- Replies: 1
- Forum: Excel Questions
