timmyotool
New Member
- Joined
- Mar 3, 2011
- Messages
- 2
Hi all,
been scratching my head and searching google for 2 hours now, hope you can help...
I'm writing a program to open certin files, go to a tab, and link to cells in another tab. Since this will happen for multiple rows, i though i'd just paste link. However, i can't get it to work without selecing the cell.
As you all know, selecting slows things down and open the code to break if someone inadvertantly clicks somewhere.
How can i link to another cell without selecting a cell/range?
currently i'm using something like this:
workbooks("1.xls").worksheets("a").range("a1:a100").copy
workbooks("1.xls").worksheets("b").range("a1:a100").paste link:=true
but i get "error 438... object doesn't support this function or method".
Thank you VERY much!
Cheers
been scratching my head and searching google for 2 hours now, hope you can help...
I'm writing a program to open certin files, go to a tab, and link to cells in another tab. Since this will happen for multiple rows, i though i'd just paste link. However, i can't get it to work without selecing the cell.
As you all know, selecting slows things down and open the code to break if someone inadvertantly clicks somewhere.
How can i link to another cell without selecting a cell/range?
currently i'm using something like this:
workbooks("1.xls").worksheets("a").range("a1:a100").copy
workbooks("1.xls").worksheets("b").range("a1:a100").paste link:=true
but i get "error 438... object doesn't support this function or method".
Thank you VERY much!
Cheers
