A simple bracket count:
BTW. If both workbooks are loaded and the ranges have the same size:Code:c01=c01 & vbcrlf & join(WorksheetFunction.Transpose(application.index(sn,j)), ",")
Code:sub m_snb() Workbooks("B.xlsm").Names("Banka").RefersToRange = Workbooks("A.xlsm").Names("Banka").RefersToRange.Value end sub
https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA




Reply With Quote
Bookmarks