Hi Everyone,

I have started programming in Excel VB about a month ago. I guess I'm
doing well but Now I have a problem at hand.

My Macro runs in a loop and searches for multiple entries one by
one ... and needs to copy the required fields corresponding to that
Entry to another sheet.

The first column in my Sheet contains the reference Entries.

I search the Entire first column for that entry and if I find it then
I need to copy SOME of the cells of that Row to another Sheet.

I can get the number of that Row by ActiveCell.Row ... and I know
which colums of that Row I need to Copy.

But I DONT know how to use both of these to Select the Required
Cell ?????

Kindly guide me ... I will be really grateful for your help.

Thanks and Best Regards,