Problems with a table

[Nomis_Eswod]

Hi,

I have a table in Excel that is split into 2 halves. Unfortunately I am unable to post it on here due to restrictions in place on my work PC, but I will try and describe it...

Row B5:F5 has titles, and rows B14:F14 has titles, and I fill in the information inbetween. I am trying to use a macro that says:

Range("B22").End(xlUp).Offset(1,0).Value = "Whatever"

Where row B22 is the bottom of the table. I want this pasted into B15, i.e. below the title that is in that row. However, it seems to skipped B14 and actually pastes under the title that is in row B5. Any ides why this might be, and how I can fix this??

Someone told me before to copy a blank cell and click on B14 and do a paste special>add, which I have tried, but it does not work.

Many thanks in advance!

 

[Andrew Poulsom]

If B4 is empty and there are no empty cells in the range B5:B22

Range("B22").End(xlUp)

will return B5.

Range("B22").Offset(-7, 0)

will return B15.

But is there some rule that determines that B15 is the cell that you want to paste into?