LinkBack URL
About LinkBacks
In the INDIRECT function use single quotes like this:
INDIRECT("'"&A2&"'!A:A")
In "exploded view":
INDIRECT(" ' " & A2 & " ' ! A:A ")
In the INDIRECT function use single quotes like this:
INDIRECT("'"&A2&"'!A:A")
In "exploded view":
INDIRECT(" ' " & A2 & " ' ! A:A ")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks