Use of & to include a cell in a reference to an external Excel table

		Microsoft Office Forums > Microsoft Excel > Excel
Use of & to include a cell in a reference to an external Excel table

FAQ

Thread Tools

Display Modes

09-21-2023, 02:18 AM

Rog7

Windows 10 Use of & to include a cell in a reference to an external Excel table

Office 2021

Novice

Join Date: Sep 2023

Location: London

Posts: 4

Thanks, that looks as though it could work but I see that INDIRECT needs all the source workbooks to be open.

I currently have over 20 such workbooks, each with 6 worksheets. So I think that's impractical.

Thanks anyway, I'll keep it in mind.

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
When inserting row in table, how do I adjust cell reference to new row	Peterson	Excel Programming	1	01-16-2022 01:06 PM
Find/Replace a cell with external reference	John Moses	Excel	1	01-03-2020 05:52 AM
Using Cell Values in Active Sheet to Populate Path to External Reference Link	wowcrofty	Excel	4	12-19-2016 12:29 PM
Reference Word Table Cell Using Offset?	wlcdo2	Word VBA	2	06-19-2016 08:53 PM
Assign the value of a cell as a cell reference of another cell in Excel 2010 - How to?	bharathkumarst	Excel	7	10-13-2014 10:25 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 01:50 PM.