View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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