Thread: Links
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karen53 Karen53 is offline
external usenet poster
 
Posts: 333
Default Links

Hi,

I've been having trouble with this. Other link inserts work but not this
one and I can't see why.

I have a main page with data starting in row 13.

I have individual sheets which are linked to the main page. I'm inserting
the links with vba.

The links where my row is less than 13 work fine. This one my row is 29 and
I keep getting a run time error 1004, application defined or object defined
error.

"'!R[+" & NextRow - 29 & "]C8"

If I'm linking to row 13 it should be R[-16]. Nextrow, being 13,
subtracting 29 gives me -16.

What am I missing?

Thanks for your help.
--

Karen