Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
I got this macro from this NG and I modified it to highlight a range. However, it's not working. Please help. Sub BordersBOLD() Application.Goto Reference:="Applicants" ActiveCell.Offset(1, 0).Select With ActiveCell ilastrow = Cells(Rows.Count, .Column).End(xlDown).Row Set rng = .Resize(ilastrow - .Row + 1, 9) 'Then I will insert a macro here to make the outline borders bold. End With End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Closing File Error | Excel Discussion (Misc queries) | |||
Name a Range - Macro | Excel Worksheet Functions | |||
Macro to edit formula | Excel Discussion (Misc queries) | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
variable range in a macro | Excel Discussion (Misc queries) |