how to select row according active cell?
 

Hi there,

i have one problem. I don`t know how can i select whole row according
activecell.
i have macro which find some data what i am looking for, and this make that
will activate cell which contain data what iam looking for. And then i need
select whole row according activecell. can anyone help me?

Thanx a lot

how to select row according active cell?
 

Hi Frankpsun,

Try:

ActiveCell.EntireRow.Select

---
Regards,
Norman


"frankosun" wrote in message
...
Hi there,

i have one problem. I don`t know how can i select whole row according
activecell.
i have macro which find some data what i am looking for, and this make
that
will activate cell which contain data what iam looking for. And then i
need
select whole row according activecell. can anyone help me?

Thanx a lot

how to select row according active cell?
 

Thanx for your help, it is working and may i have another question.
Iam working on searching formular. i made search function where i will
search text into textbox1 and then by function find iam seaching trough range
for searched text. And i need result of search put into listbox, but i need
if find function will find some cell where is my searched text in order to
add row with data where searched text was found into listbox. Do you have
some idea how to make it, i have a lot of problems with this.

thanx for your help
regards
frankosun

Norman Jones pÃ*Å¡e:

Hi Frankpsun,

Try:

ActiveCell.EntireRow.Select

---
Regards,
Norman


"frankosun" wrote in message
...
Hi there,

i have one problem. I don`t know how can i select whole row according
activecell.
i have macro which find some data what i am looking for, and this make
that
will activate cell which contain data what iam looking for. And then i
need
select whole row according activecell. can anyone help me?

Thanx a lot