Need to boost the visibility of your question for solutions? Use the Experts Exchange Help Bell to confirm priority levels and contact subject-matter experts for question attention. Check out this how-to article for more information.
With shtFrom.Range("tbl_import") 'collect last row lastrow = shtFrom.Cells(2).CurrentRegion.Columns(1).SpecialCells(xlCellTypeVisible).Count - 1 'Range("A2 " & L & lastrow).Select csb_import = Range("A2:L & lastrow) ActiveWorkbook.Names.Add Name:="csb_import", RefersTo:=csb_import 'allocate from range Set rngFrom = Range("csb_import")
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
Join the community of 500,000 technology professionals and ask your questions.