Hi,Sorry, didn't see that it might go past 100. This is better: Sub selectCells() Dim i As Integer For i = 1 To 10000 If Cells(i, 1) = "" Then Cells(i, 1).Select: Exit For Next iEnd Sub Regards from Brazil.Dave. Date: Sat, 12 Jun 2010 21:48:01 +0530 Subject: Re: $$Excel-Macros$$ From: deepaktheind...@gmail.com To: excel-macros@googlegroups.com
Thanks Mahesh it works, I've an another query for you, i'm writing a code which is given below, now in the following loop range from A1 to A100 will be selected, but I want to select each cell one by one untill an empty cell comes, it can be after 100 or before 100, that's wha idon't know. Sub selectCells() Dim i As Integer For i = 1 To 100 Cells(i, 1).Select End Sub Thanks On Sat, Jun 12, 2010 at 6:46 PM, Mahesh parab <mahes...@gmail.com> wrote: Hi Deepak find attach sheet, hope its as per u r requirement. Change Mypath in Module2. On Sat, Jun 12, 2010 at 8:17 AM, Deepak Pal Singh <deepaktheind...@gmail.com> wrote: Hi All, I've some data in sheet1, people have to work on this data, i've assigned the work to the concern people, now what i want a macros should be run and then new files should be created ion the same folder in the name of assigned peoples and those files should contain individual works that i've assigned in the attached file. Example there are 3 people who have to work on different states no i what i want to do is if i run a macro then 3 new files should be created in the name of people who will work on the data, and each file must contain the work assigned to them. Thanks Deepak Kumar -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe _________________________________________________________________ View photos of singles in your area! Looking for a hot date? http://clk.atdmt.com/NMN/go/150855801/direct/01/ -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
