Repost of listbox losing linked cell
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
|