LInks

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

Hi! Friends:

I have 2 question which need your helps:


1. I have a big Excel file (the target) in which some of
the cells are linked to another Excel file (the source).
By looking at EDIT/LINK of the target, I can only know the
name of the source file. How can I do a quick search in
the Target to know the cell addresses to which it is being
linked?

2. In VBA, is there a way to 'declare' all variables are
positive, similar to the INTEGER statement used to declare
integer variables?

Thanks.

Lee
 
Back
Top