Hi, I have a macro that builds a grid to use as a map, my sheet starts with a 36 cell range from B2:G7 that is already filled out and formatted correctly. Each cell has a thin border, and there is a thick border that encloses all 36 together. To build the map my code copies the range from B2:G7 and offsets it. Everything works as it should except I lose the thick border around my range. Does anyone know how I can modify my code so that the thick border will be copied and pasted as well?
NR and ND are variable that are given values through a lot of calculation that i omitted from this posting![]()
Dim NR As Double Dim ND As Double Dim NRV As Double NRV = 1 Dim NDV As Double NDV = 1 Dim Sections As Range Set Sections = Sheets("Map").Range("b2:g7") Sections.Copy Do Until NRV = NR Sections.Offset(0, NRV * 6).PasteSpecial xlPasteAll NRV = NRV + 1 Loop Dim sv As Range With ActiveSheet.UsedRange Set sv = .Offset(1, 0).Resize(.Rows.Count - 1) End With sv.Copy Do Until NDV = ND sv.Offset(NDV * 6, 0).PasteSpecial xlPasteAll NDV = NDV + 1 Loop
Bookmarks