Dim X as long
for X=1 to 65536
If cells(X,"x")="" then
msgbox x
exit for
end If
Next X

tig wrote:
I need to find the first row in column X where the value = "". By
value I mean the value of the formula. I have a formula in 1 through
65536 as I don't know how many rows the user is going to need from one
day to the next.

Any ideas??


TIA