selecting part of a row from an activecell

[Trident1]

I've written a macro to find an individuals name in a full column of names, from a normal type of user/password type entry.

Having found the name in the column, I want to copy the information contained in the six cells to the right of what is now the activecell, and paste it in another worksheet.

I have tried the offset function but this just copies a single cell.

It didn't appear to be that hard when I started!!

Anyone....?????

 

[TonyJollans]

Hi Trident1,

You need to resize the range ..

[blue]ActiveCell.Offset(, 1).Resize(1, 6).Copy [i]YourOtherSheetTargetRange[/i][/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.
Excel VBA Training and more Help at VBAExpress[