Dynamically changing named range

I have a spreadsheet with the column headers in row 3 (it is generated on a daily basis so I cannot change how it is sent to me). I have to take this daily and delete the top 2 rows before I can import into Access, what I would like to do instead is have a macro that will just create a named range.

The spreadsheet will always have the column headers in row 3. The columns extend out to column Y (25) however the number of rows will vary depending on how far into the month we are (beginning of the month its empty and will grow as the month continues).

Any help is greatly appreciated!

Saved to your Personal.xls and used when needed:

Please Login or Register  to view this content.

Change name ("Mydata") to suit.
Number of rows to return is based on count of used rows on Column-A