<div>
Sorry is this VBA or it is a formula ?<br />
if it is a formula then presume all of<br />
LastRow<br />
Start_Row<br />
Start_Pass<br />
are named ranges ??<br />
can you post a sample workbook ? as cannot see how you LastRow get updated when you add data !!!<br />
<br />
gowflow
</div>


Sorry is this VBA or it is a formula ?
if it is a formula then presume all of
LastRow
Start_Row
Start_Pass
are named ranges ??
can you post a sample workbook ? as cannot see how you LastRow get updated when you add data !!!

gowflow

<div>
it's not vba,yes they are name ranges
</div>


<div>
can you post a workbook ?<br />
gowflow
</div>


<div>
point taken.looking at the workbook I think a simpler &nbsp;approach would be to return the address of the last row text or numeric since the &nbsp;data is mixed
</div>


point taken.looking at the workbook I think a simpler  approach would be to return the address of the last row text or numeric since the  data is mixed

<div>
<div class="content wysiwyg-content">
i am import data from various workbook i am using the formula to determine what row to start on the worksheet i would eventually like to apply it to a name range.I am looking for the most efficient way Thanks<br />
=IF(ROW(LASTROW)&gt;ROW(START<wbr />_ROW),ADDR<wbr />ESS(ROW(LA<wbr />STROW)+1,1<wbr />),IF(ROW(S<wbr />TART_PASS)<wbr />=2,ADDRESS<wbr />(ROW(START<wbr />_PASS)-1,1<wbr />),ADDRESS(<wbr />ROW(START_<wbr />PASS),1)))<wbr />
</div>
</div>


i am import data from various workbook i am using the formula to determine what row to start on the worksheet i would eventually like to apply it to a name range.I am looking for the most efficient way Thanks
=IF(ROW(LASTROW)>ROW(START_ROW),ADDRESS(ROW(LASTROW)+1,1),IF(ROW(START_PASS)=2,ADDRESS(ROW(START_PASS)-1,1),ADDRESS(ROW(START_PASS),1)))

more efficient formula

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.