Thread
:
Drag and Drop into an input range results in #REF! error
View Single Post
02-20-2020, 10:16 AM
p45cal
Windows 10
Office 2019
Expert
Join Date: Apr 2014
Posts: 872
Use Indirect, eg.:
=INDIRECT("B5")
and to avoid loads of formulae with Indirect in, you could put formulae such as the above in only a few cells and have the more complex formulae refer to those cells insteasd of the ones being drag'n'dropped to
p45cal
View Public Profile
Find all posts by p45cal