Home |
Search |
Today's Posts |
#10
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Zero in cell where it is linked to a blank cell - repost | Excel Worksheet Functions | |||
Listbox linked cell does not change | Excel Worksheet Functions | |||
Repost of Listbox Headers | Excel Programming | |||
ListBox (finding Repost) (try to line up my example) | Excel Programming |