Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I know how to define a range using Excel's Offset function (OFFSET(Rows,
Columns, Height, Width)) But how do I do it using the VBA Offset function. It only includes (OFFSET(Rows, Columns)). I am trying to count the blank cells betwee rows 2 and rows 65236 on a sheet. Row 2 is named PasteStartCell. I think the use below does not define a range between row 2 and row 65536. It simply defines row 65536 as I am offsetting row 2 by 65535 additional rows. How do I make it refer to the range itself. Note I do not what to select the range and it cannot include row 1 Numblanks = Application.WorksheetFunction.CountBlank(Range(Pas teStartCell.Offset(65535,0))) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Counting Blanks | Excel Discussion (Misc queries) | |||
counting non-blanks | New Users to Excel | |||
counting blanks in a non-consecutive range | Excel Discussion (Misc queries) | |||
copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
Counting blanks, either 1, 2 or 3 | Excel Worksheet Functions |