selecting range after finding address

[nicbrez]

I have found the address of a cell with a value I am searching for and stored it in a variable called FoundAddress.

What is the easist way of then selecting a range of the 10 rows below this address and copying them into another sheet?

Cheers

Nic

 

[brian.wethington]

Could you post the code in question. I would say it is best to find a cells range then if the range is found use that range to dynamically set up your following range however, it is highly unlikely that you would need to select a range to copy, and then paste the range elsewhere.

 

[Lewiy]

Try this:

Range(FoundAddress).Offset(1, 0).Resize(10, 1).Select

 

[Lewiy]

Or to copy it to Sheet 2 column A:

Range(FoundAddress).Offset(1, 0).Resize(10, 1).Copy Destination:=Sheets("Sheet2").Range("A1")

 

[nicbrez]

thanks guys worked a treat