Where does the error appear?
Regards
strAddress = Evaluate("=ADDRESS(ROW(Analysis),COLUMN(Analysis))&"":""&ADDRESS(ROW(Analysis)+ROWS(Analysis)-1,COLUMN(Analysis)+COLUMNS(Analysis)-1)")
lstTopic.ListFillRange = "Topics!" & strAddress
to see if it evaluates the Named Range correctlyTitle | # Comments | Views | Activity |
---|---|---|---|
Excel VBA - Collection of checkboxes and labels on UserForm | 8 | 26 | |
Auto Operation of MS Excel 2013 | 2 | 29 | |
How do I get the names of each Excel workbook located in a folder with a macro? | 6 | 47 | |
Add macros on Open | 9 | 29 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!