View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Per Jessen[_2_] Per Jessen[_2_] is offline
external usenet poster
 
Posts: 703
Default Is column below title row blank

I think this is what you need:

Public Function IsColumnBlank(argTitleRows As Long, argColNum As Long)
As Boolean
Application.Volatile
LastDataRow = Cells(Rows.Count, argColNum).End(xlUp).Row
If LastDataRow = argTitleRows Then
IsColumnBlank = True
End If
End Function

Regards,
Per

On 22 Jul., 16:19, xp wrote:
Using Office 2007;

I need a function that would select the used range of a column below a
specified number of title rows and return true if this area is blank (i.e. no
entries of any kind apart from the title row(s).)

For example:

Public Function IsColumnBlank(argTitleRows as Long, argColNum as Long)
'select area below title rows specified
'determine if this area is blank
'return true if blank; false if not blank
End Function

Thanks for any help you may provide.