selecting rows

[Luis939]

I want to be able to record the row of my activecell, thats no problem, but now i need to select all the rows between that row and the row of a cell i found before

i tried this

Let cellAdress2 = ActiveCell.Row
Rows("cellAddress1:cellAddress2&quot.Select

'cellAddress1 is the row stored from the first cell I found,
I keep getting a type mismatch error, can anyone help??

After I do this, I'll just copy and paste it onto another file, but i want to paste it starting at row 2, How would I do this without using

Range("A2&quot.Select

thanks!

 

[Loomah]

Hi
For the first part of your question you just have the quotes in the wrong places - trust me, easily done!!

Try

Rows(row1 & ":" & row2).Select

For the second part what are you copying? Assuming the selected rows then

selection.copy destination:=Workbooks("Your book&quot.Worksheets("Your sheet&quot.range("your range&quot

should do the trick.
;-)

If a man says something and there are no women there to hear him, is he still wrong?

 

[Luis939]

YOUR BEAUTIFUL!!! I keep forgetting that concatenation business, so yes this man is always wrong, but luckily I have you to correct me, thanks!