Search:

MS Office Answers

Ask Question UnAnswered

Home » Forum » MS Office

RSS Feeds

Question Asked By: Molly Brown on Sep 01 In MS Office Category.

Fill Blank rows

Question Answered By: Guadalupe Rogers on Sep 01

If you change your IF statement slightly, you can use your existing
logic:

IF IsEmpty rngCell.Value AND IsEmpty rngCell.Offset(0,4).Value Then

' DO stuff
Else
' Do nothing
End If

This Question has 2 more answer(s). View Complete Question Thread

Didn't find what you were looking for? Find more on Fill Blank rows Or get search suggestion and latest updates.

Related Topics:

Select a Range and one blank row above
Counting the rows If the next row value is same as the previous row
Delete Part of Row and move next Row Down Up
Move data from a column of row couplets to multiple rows of colum
Userform Blank/empty textboxes
screen goes blank after 15 min of inactivity screen saver set for 130 mins
Blank screen
Blank Screen with 8.04 Pendrive Installation
Formatting SQL Crosstab Query to return the blank fields
Simplest way to check for a blank worksheet in an excel workbook
Blank Formula bar
Create a blank file
Blank Lines Removal
fill series and select a range
Fill color
How can I fill all combinations of x and y in columns A and B
Fill List Box Based On Selection On Other List Box
Fill VBA form with Cell values of an Excel sheet
fill range not working
Merge a series of rows with the same ID reference to a single row automatically using VBA.

Tagged:fill blank rows

RSS Feeds:	Articles \| Forum \| New Users \| Activities \| Interview FAQ \| Poll \| Hotlinks
Social Networking:	Hall of Fame \| Facebook \| Twitter \| LinkedIn
Terms:	Terms of Use \| Privacy Policy \| Contact us