userform with formulas

[daffy]

Hi All

Im stuck.
I have build a userform that works great on the blank sheet i have built it on.
The form is for entering data and always looks for the first blank line.

However if i add formulas to the blank lines the userform thinks this as a non blank line and moves down to the first completly blank line.

What i need is for the code to ignore the formulas and load the data to that line.

when i copy the userform to the sheet that it was made for i get an
error 9 message when i try to add any data

Thanks in advanced of any help

 

[daffy]

Ok guys

Here goes
the userform will populate the speadsheet.

The cells that are populated have no formulas in them.

Some of the other columns have formulas all the way down to about cell 250

For an example column "s" may have a formula in that works out when a person is 70 from a cell populated by the userform (does that make sense?)

The problem seems to be that the code seem to think that a row isnt blank if it has a formula in it. So it cant find a blank row.

Thanks in advanced guys

Don