<div>
Try:<br />
<br />
=OFFSET(Sheet1!$A$5,0,0,CO<wbr />UNTA(Sheet<wbr />1!$A:$A),4<wbr />)<br />
<br />
this assumes nothing in column A above row 5
</div>


Try:

=OFFSET(Sheet1!$A$5,0,0,COUNTA(Sheet1!$A:$A),4)

this assumes nothing in column A above row 5

<div>
Yes, there is data in rows 1 to 4 which is why I need I to start at row 5. &nbsp;Right now, it is not working.
</div>


Yes, there is data in rows 1 to 4 which is why I need I to start at row 5.  Right now, it is not working.

<div>
They both worked Nd the explanation helped.<br />
<br />
Sandra
</div>


They both worked Nd the explanation helped.

Sandra

<div>
I'm glad I was able to help.<br />
<br />
Marty - MVP 2009 to 2013
</div>


I'm glad I was able to help.

Marty - MVP 2009 to 2013

<div>
<div class="content wysiwyg-content">
Normally I could do this, but am so tired brain is not working. &nbsp;I have data in a worksheettaht starts at cell A5 and goes to column D. &nbsp;I am trying to create a dynamic named ranged,but simply am too tiredto analyze the statement<br />
<br />
=OFFSET($A$5,0,0,COUNTA($A<wbr />:$A),1)<br />
<br />
To figure out how to get it to cover columns A:D, start at row 5 and then capture any changes the user makes.<br />
<br />
Sandra
</div>
</div>


Normally I could do this, but am so tired brain is not working.  I have data in a worksheettaht starts at cell A5 and goes to column D.  I am trying to create a dynamic named ranged,but simply am too tiredto analyze the statement

=OFFSET($A$5,0,0,COUNTA($A:$A),1)

To figure out how to get it to cover columns A:D, start at row 5 and then capture any changes the user makes.

Sandra

Dynamic range in Excel 2010- how to set it up

Microsoft applications include a variety of software programs, including development and digital authoring programs (Expression and Media Center), educational programs, Internet software, including Essentials, Skype and the Live family, anti-virus, productivity applications and suites like Office, Excel, Word, Outlook, Access and PowerPoint, video games and server applications such as Exchange, SharePoint, IIS and Virtual Server.

Microsoft Applications

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

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