Determining if certain row # is blank

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would greatly appreciate any help in writing the necessary line(s) of code
to determine if a given row (e.g., 8) in the active workbook is completely
blank.
Thanks,
Bob
 
this should return a zero if the row is blank:

application.counta(rows(8))
 
One way:

Dim bLine8IsBlank As Boolean
bLine8IsBlank = Application.CountA(ActiveSheet.Rows(8)) = 0
 
You must log in or register to reply here.

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

Copy Active Range from one workbook to another 1
Is column below title row blank 1
determining whether all cells in a row are blank 2
Get Data set range from closed workbook 2
Determine the Empty row and/or column 1
Finding completely blank rows 2
Array Formula In IF Function 0
Code To Insert Blank Rows 5

Back
Top