Countblank

I have this formula that i will be doing a paste special (formula) on

=(CELL("row")-CELL("row",B109)-COUNTBLANK(B129:cell("address"))

it should number my rows 1,2,3,4,5,ect.. with my different sized merged cells (hence why i just dont drag the numbers to automatically number my rows, it throws a error "This operation requires the merged cells to be identically sized numbers")

why will it not let me combine the cell call with the COUNTBLANK?

i also know VB and if anyone knows a macro that can help me or a different formula that would be great but this should work.

Humm returns Zero maybe a countif

=(CELL("row")-CELL("row",B109)-COUNTIF(INDIRECT("B129:"&CELL("address")),""))

i tried that indirect it did not work just returned zero again

I'm attempting to number Steps on a testing procedure by numbering the rows but some test steps and multiple combined rows that are combined using merge cells and i cannot start the sequence of numbers by filling in the first 2 rows and dragging the auto complete down to automatically fill in the step numbers (the rows) from 1 to 2264.

Because some steps contain multiple merged rows i cannot use the auto complete function because it throws this error "This operation requires the merged cells to be identically sized numbers".

B109 is where the data starts and b129 is the step i got to manually typing the number in and realized it would take forever to do 2000+ steps. so i need a call formula or a VB script that numbers these steps

Based on nothing more than your sample file the below would be a very rough example...

Sub Example()
Dim lngRow As Long, lngCount As Long
For lngRow = 2 To 1000 Step 1
    lngCount = lngCount + 1
    Cells(lngRow, "A").Value = lngCount
    If Cells(lngRow, "A").MergeCells Then lngRow = lngRow + (Cells(lngRow,"A").MergeArea.Rows.Count - 1)
Next lngRow
End Sub

obviously you will need to revise your range (start/end row based on range content in another column perhaps ?)

One point I would make re: pasting formulae into merged areas etc is that even if the results appears only in top left cell of area the formula still exists in all cells that are not visible... to illustrate using your file... if you were to enter:

A2: =1+MAX(A$1:A1)

and copy / paste special / formula over A3:A12 you would find that the "hidden" cells are still populated and return results as they would were they not merged.

wow your going to laugh but..

=B109+1

in cell B110 and then i did a copy and a paste special formula on the selected range of cells and it worked....i could of swore i tried this before i even posted on the forums.

I'm running excel 2010