Hi
try
scrNumber = application.worksheetfunction.max(activesheet.rang e("D:D"))

--
Regards
Frank Kabel
Frankfurt, Germany

I have a texbox that gets its value, on "Initialize", from a
scrollbar.

txtNumber = scrNumber

My problem is that i want the value of "scrNumber", on "Initialize",
to be the same as the Max value of column D.

Many thanks


---
Message posted from http://www.ExcelForum.com/