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
>
>
>