VBA code using Find to locate text and display the Cell Range.

Hi is there a where a way to display the Column and Row Number on the vb code?

Thanks

What do you mean?

Can you post the code you are using?

Msgbox ActiveCell.Row
Msgbox ActiveCell.Column

VB code does not have Columns and Rows, just lines.
"slimla" <slimla@discussions.microsoft.com> wrote in message
news:F4294A60-4A7C-498E-92D9-139786120C00@microsoft.com...
> Hi is there a where a way to display the Column and Row Number on the vb
> code?
>
> Thanks

Actually,

What I'm trying to achieve is selecting the Range from a Activecell to a
specfic number.

Since my Activecell is not constant, that why I have to first use the Find
Function then select the cell 10 below plus 10 cells down and copy and paste
it somewhere else.



"Mike Fogleman" wrote:

> VB code does not have Columns and Rows, just lines.
> "slimla" <slimla@discussions.microsoft.com> wrote in message
> news:F4294A60-4A7C-498E-92D9-139786120C00@microsoft.com...
> > Hi is there a where a way to display the Column and Row Number on the vb
> > code?
> >
> > Thanks
>
>
>

I think I can answer part of your question. To get the row and column of
your active cell, you coud use:
iColumn = ActiveCell.Column
iRow = ActiveCell.Row

I don't know what you mean by "the cell 10 below plus 10 cells down", but if
you want to access the cell 10 rows below the active cell and the same
column, you could use:
ActiveCell.Offset(10, 0)

If you want to select the range from the active cell to the cell 10 rows
below, you could do:
Range(ActiveCell, ActiveCell.Offset(10, 0)).Select

Does that help?
--
Assigning guilt doesn't solve the problem


"slimla" wrote:

> Actually,
>
> What I'm trying to achieve is selecting the Range from a Activecell to a
> specfic number.
>
> Since my Activecell is not constant, that why I have to first use the Find
> Function then select the cell 10 below plus 10 cells down and copy and paste
> it somewhere else.

Thanks that's what I need.

"LabElf" wrote:

> I think I can answer part of your question. To get the row and column of
> your active cell, you coud use:
> iColumn = ActiveCell.Column
> iRow = ActiveCell.Row
>
> I don't know what you mean by "the cell 10 below plus 10 cells down", but if
> you want to access the cell 10 rows below the active cell and the same
> column, you could use:
> ActiveCell.Offset(10, 0)
>
> If you want to select the range from the active cell to the cell 10 rows
> below, you could do:
> Range(ActiveCell, ActiveCell.Offset(10, 0)).Select
>
> Does that help?
> --
> Assigning guilt doesn't solve the problem
>
>
> "slimla" wrote:
>
> > Actually,
> >
> > What I'm trying to achieve is selecting the Range from a Activecell to a
> > specfic number.
> >
> > Since my Activecell is not constant, that why I have to first use the Find
> > Function then select the cell 10 below plus 10 cells down and copy and paste
> > it somewhere else.
>

ActiveCell.Resize(10,10).copy would make a 10 x 10 range

or perhaps for a single cell offset from the active cell
ActiveCell.Offset(9,9)

to demo from the immediate window:
? Range("A1").Offset(9,9).Address
$J$10


--
Regards,
Tom Ogilvy

"slimla" <slimla@discussions.microsoft.com> wrote in message
news:BB4BF4BF-E9F3-455B-B65D-83798235BA61@microsoft.com...
> Actually,
>
> What I'm trying to achieve is selecting the Range from a Activecell to a
> specfic number.
>
> Since my Activecell is not constant, that why I have to first use the Find
> Function then select the cell 10 below plus 10 cells down and copy and
paste
> it somewhere else.
>
>
>
> "Mike Fogleman" wrote:
>
> > VB code does not have Columns and Rows, just lines.
> > "slimla" <slimla@discussions.microsoft.com> wrote in message
> > news:F4294A60-4A7C-498E-92D9-139786120C00@microsoft.com...
> > > Hi is there a where a way to display the Column and Row Number on the
vb
> > > code?
> > >
> > > Thanks
> >
> >
> >