Please use ActiveSheet.UsedRange.Select, if you are changing data daily. It will select only the range you have used.
Paul On Sat, May 16, 2009 at 7:27 AM, Joyce Garza <tuig...@gmail.com> wrote: > Attached is an example of the excel file I am working with. > This data is imported from another database application with formatting and > extra data that I do not need. > > Also attached are the 2 macros that I use to format and organize the data I > want to keep. > Notice that after running the 1st macro I can now delete the last few rows > of data that are irrelevant to my needs. > So I delete these rows and continue with the 2nd macro. > > How can I use VBA to define this variable range (the data changes from day > to day) and then identify and delete the irrelevant rows at the bottom and > continue with the instructions in the 2nd macro. > I want to get all this done in one macro but since the range is variable I > need to stop the procedure and manually delete the rows I do not want to > keep and then continue with 2nd macro. > > If anyone can solve this problem I would be extremely thankful. > > > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
