Repost of listbox losing linked cell
Maybe...
just in case Inputs wasn't the activesheet -- or the code was located behind a
different worksheet so that that unqualified range wouldn't refer to ws.
<vbg
Norman Jones wrote:
Hi Dave,
'----------------
I'd use that same syntax as you used in the .listfillrange
.LinkedCell = ws.Range("AK5").Address(external:=True)
Just in case Inputs wasn't the activesheet.
'----------------
I certainly agre that it is better to be explicit.
However, given Dkline's
ws.Select
The activesheet should not be a problem.
---
Regards,
Norman
--
Dave Peterson
|