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