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
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