D
Dantz
i have a named range "second_column" which has a range lets say
D6 to D14
it is in a table form where the D14 bottom border is xlMedium,
my problem is that I want to redimension my named range when the user
creates a new row and have it as the last row in column D(changing its
bottom border to xlMedium) is there a way to find it?
my codes is like this:
' i also don't know how to loop in the column
'covered by "second_column"
For Each cell In Range("second_column") ' how can i know the column
If cell.Borders(xlEdgeBottom).LineStyle = xlContinuous _
And cell.Borders(xlEdgeBottom).Weight = xlMedium Then
Set bottom_cell = cell
End If
Next
Range(Range("second_column"), bottom_cell).Select
ActiveWorkbook.Names.Add Name:="second_column", _
RefersToR1C1:=Selection.Address(, , xlR1C1)
please help me...
thanks in advance
D6 to D14
it is in a table form where the D14 bottom border is xlMedium,
my problem is that I want to redimension my named range when the user
creates a new row and have it as the last row in column D(changing its
bottom border to xlMedium) is there a way to find it?
my codes is like this:
' i also don't know how to loop in the column
'covered by "second_column"
For Each cell In Range("second_column") ' how can i know the column
If cell.Borders(xlEdgeBottom).LineStyle = xlContinuous _
And cell.Borders(xlEdgeBottom).Weight = xlMedium Then
Set bottom_cell = cell
End If
Next
Range(Range("second_column"), bottom_cell).Select
ActiveWorkbook.Names.Add Name:="second_column", _
RefersToR1C1:=Selection.Address(, , xlR1C1)
please help me...
thanks in advance