Thanks Dave & Mahesh, I solved my query with the help of you..:-)
On Sun, Jun 13, 2010 at 10:19 AM, Mahesh parab <mahes...@gmail.com> wrote:
> Hi Deepak
>
> Try
> Sub FindCell()
> Dim FirstCell As String
> Dim i As Integer
> FirstCell = "A1"
> Range(FirstCell).Select
> Do Until ActiveCell.Value = ""
> If ActiveCell.Value = "" Then
> Exit Do
> Else
> ActiveCell.Offset(1, 0).Select
> End If
> Loop
> End Sub
>
> Or to select the range from last blank cell
>
> Sub LastCellBeforeBlankInColumn()
> Range("A1").End(xlDown).Select
> Range(Selection, Selection.End(xlUp)).Select
> End Sub
>
> On Sun, Jun 13, 2010 at 1:13 AM, Dave Bonallack <davebonall...@hotmail.com
> > wrote:
>
>> 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 i
>> End 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
>>
>> ------------------------------
>> Looking for a hot date? View photos of singles in your
>> area!<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
>>
>
> --
>
> ----------------------------------------------------------------------------------
> 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
