Macro Range Code based on Data Size

[serpent333]

OK.....so I have a huge report of hotel guets requests that are dumped out of my wed based system into an excel workbook at the end of every month. The data is 26 or so columns wide, and usually between 2500 and 3000 rows long. I have to generate a report with different graphs and figures based on this info every month; the graphs use the same columns everytime, but obviously the number of rows of data in the worksheet changes every month.

I'm currently trying to develop Macros for the graphing and data filtering (since doing it manually takes a LONG time each month)......my problem is that I dont know how to create a Macro where the range is self-adjusted based on the last filled-in row. Is there a way that Excel can determine what the last filled row is and adjust the range each time based on that value.

Thanks in advance!

[VBA Noob]

Non VBA way

http://www.contextures.com/xlNames01.html#Dynamic

VBA Way

http://www.rondebruin.nl/last.htm

http://www.ozgrid.com/VBA/ExcelRanges.htm

http://www.vbaexpress.com/forum/showthread.php?t=9774

VBA Noob

[serpent333]

Thanks Noob - I really appreciate it.

I also wanted to ask you if you think VBA macros are the best way to go about generating reports. I know that there are other ways (report wizards) that can be created in Excel....but as an amateur I'm not sure what the best route would be. Any ideas?

Thanks again!

[VBA Noob]

Depends what your doing. Link explains best practice for Design a sheet

http://www.ozgrid.com/Excel/ExcelSpreadsheetDesign.htm

VBA Noob