Hi,

Is the only way to select the first non blank cell in a range to use an
if statement.

e.g If D1 is the first cell in range A1 to F1 with info I want to
return 1 for A to for B and so on. So D1 would return 4

VBA Noob


--
VBA Noob
------------------------------------------------------------------------
VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833
View this thread: http://www.excelforum.com/showthread...hreadid=564240