Thread: combobox code
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default combobox code
Try in the below format...Rename the sheet name to suit.

='d:\[B.xlsx]Sheet1'!$A$1:$C$46

--
Jacob


uk" wrote:

=D:\[B.xlsx]!sht!A1:c46

i have tried the above code and several variations of it but i can't get the
data from book b
Reply With QuoteReply With Quote