Macro for adding rows if two different columns have a value

S

Saveset

Help! I need a macro to add a row after if the cell in column F has a value
and again if there is a value in column G
 
J

JLGWhiz

For Each c In Range("F2:F20") 'Or whatever size range
If c.Value > "" And c.Offset(0, 1).Value > 1 Then
c.Offset(1, 0).Resize(2, 1).EntireRow.Insert
ElseIf c.Value > "" Then
c.Offset(1, 0).EntireRow.Insert
End If
Next
 
S

Saveset

Thank you JLGWhiz! You are a Time saver for me! Also I appreciate the help
since I am just learning about the VBA process.
 
S

Saveset

Thanks! This did exactly what I needed!!! I truely appreciate this since I am
just beginning to learn about Macros!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop down list control value in vba 2
Setting column width in a table with a macro is not working 0
VBA Coding Help for Beginner 0
Cumulative formula for word table 0
Cell data entering slow! 0
Adding a big matrix in Word 2013 5
Calculate the median value before a specified list 0
Newbie Help - IF Yes No Function 0

Top