Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is column below title row blank
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Insert Column after specific text title the new column and add for | Excel Discussion (Misc queries) | |||
Column Title | Excel Discussion (Misc queries) | |||
Column Title changes | Excel Discussion (Misc queries) | |||
Named range=Column title,comumn title in cellB6 use B6in equation | Excel Discussion (Misc queries) | |||
Sumif based on column A and title of another column | Excel Discussion (Misc queries) |