View Single Post
 
Old 02-19-2020, 10:34 AM
DJ0691 DJ0691 is offline Windows 10 Office 2013
Novice
 
Join Date: Jan 2020
Posts: 18
DJ0691 is on a distinguished road
Default Drag and Drop into an input range results in #REF! error

Hi all,
I have worksheet with an input range of, for example, N2:O2. There are a number of formulas in adjacent cells that reference N2 and O2. The formulas work fine when the entries are input via Ctrl+V or manually typed in.

To speed things up, since the input data is another area in the same worksheet, I'd like to enable the users to simply drag and drop into N2 and O2, however, the formulas error
out immediately with #REF! since perhaps the relative references appear to have been impacted.

I've tried changing the formulas to absolutes but that had no positive impact.

Any ideas? Many thanks!
Reply With Quote