Help With Excel Loop Macro

April 11, 2011 at 02:14:34
Specs: Windows 7
Hi I need the following formula to loop down the page and stop at every blank line then carry on , This is to be done using coloum G.
Below is the formula,


im thinking this has to be done in a VB Macro but cannot figure out what the code should be..... Thank you

See More: Help With Excel Loop Macro

Report •

April 11, 2011 at 12:14:20
Can't help you with a Macro, but why can't you just drag the formula down the sheet?


Report •

April 12, 2011 at 08:45:01
Sub FindBlankCell()
Dim iEndRow As Long, r As Long
iEndRow = Range("G65536").End(xlUp).Row

For r = 1 To iEndRow
If Range("G" & r).Value = "" Then
Range("G" & r).Value = "Blank Cell" 'here is the blank row so enter whatever value you want in place of "Blank Cell"
End If
End Sub

Report •
Related Solutions

Ask Question