Dear All , I am the beginnar of vba .I never have exposured of seeing very good and complex kind of application of xl that built with vba code.So please send me some of good xl books that have lot of vba codes to follow . I m realy great full to you . Allah Hafiz ,Kamran Haider . > Date: Tue, 28 Oct 2008 21:12:24 -0700> Subject: $$Excel-Macros$$ Number ranges in a cell> From: [EMAIL PROTECTED]> To: excel-macros@googlegroups.com> > > Hi, I need help with a spreadsheet. The spreadsheet is created using a> program I have no control over. I have a column that can contain weeks> that a course is run. It seems to come out in the following formats:> > Weeks> 10 - 12> 8> 6, 11 - 12> 4 - 6, 8 - 10> 3 - 7, 11> > I want to split each and have a comprehensive list of the weeks. I> want it to look like this:> > 10 11 12> 8> 6 11 12> 4 5 6 8 9 10> 3 4 5 6 7 11> > But I have thousands of rows and do not want to do it manually. I have> tried using text to columns in many different ways and was able to> get:> > 10 12> 8> 6 11 12> 4 6 8 10> 3 7 11> > But this does not help. You don't know now if the first one was 10 and> 12 or 10 through 12. Can anyone help? I have a nifty macro to count up> the final number of weeks and insert that many rows underneath to have> a line for each week the course but I just can't work out an automatic> way to get all the course weeks in separate cells.> > _________________________________________________________________ Invite your mail contacts to join your friends list with Windows Live Spaces. It's easy! http://spaces.live.com/spacesapi.aspx?wx_action=create&wx_url=/friends.aspx&mkt=en-us --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
