Hi,

I have worksheets containing links to the main page and vice versa. The
links are inserted by vba. The main page needs to be in order. How can I
sort and not lose my links? I am assuming R[3]C[-2] might do it? In this
case the columns will be constant but the rows will change, so R is a
variable. How would I do this using a variable since I don't know where the
row will be? Or would I still lose my links?

I tried this but did not get the results I was looking for.

"'!R[-" & NextRow - 2 & "]C5"

The cell containing the link is in row 2 of the worksheet.

Thanks for your help.
--

Karen

Hi,

I got it. It should have been plus not minus.

R[+" & NextRow - 2 & "]C5

duuuuuuuhhh!!

--

Karen


"Karen53" wrote:

Hi,

I have worksheets containing links to the main page and vice versa. The
links are inserted by vba. The main page needs to be in order. How can I
sort and not lose my links? I am assuming R[3]C[-2] might do it? In this
case the columns will be constant but the rows will change, so R is a
variable. How would I do this using a variable since I don't know where the
row will be? Or would I still lose my links?

I tried this but did not get the results I was looking for.

"'!R[-" & NextRow - 2 & "]C5"

The cell containing the link is in row 2 of the worksheet.

Thanks for your help.
--

Karen