Selecting a group of Cells in a unknown row (Excell 2k)

[apeoortje]

I'm in the process of writting a macro to a number of cells into another workbook.

the only problem I'm having that the Macro I'm writing needs to find the row it's self before it able of copy the Data. What I need to do is to copy Cells on the Active row from A to D collumn. but I stuck!!

I can get to whole row, but don't just those cells

I was thinking something like this

bob = activecell.Row
range("A" & bob:"C" & bob).select

but that doesn't work

CAn anyone help me?

 

[TonyJollans]

Hi apeoortje,

Almost there - the colon needs to be inside the quotes ..

[blue]Range("A" & bob [red]& ":[/red]C" & bob).select[/blue]

Enjoy,
Tony

--------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading this: Before you ask a question.

 

[apeoortje]

Thank you VERY Much

It's been driving me mad