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
