View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BEEJAY BEEJAY is offline
external usenet poster
 
Posts: 247
Default Borders on Fixed # of Columns, Variable # of Rows

Looking to put "std" width borders on all but outside edges of range
which should be "heavy"
Getting stuck identifying the "variable" range.

Fixed Columns: B3 thru F3
Variable Rows: Any possible number

I got:

LastRow = Worksheets(1).Cells(Rows.Count, "E").End(xlUp).Row
Range ("B3:G" & LastRow) <<<<<<< Comes up as "COMPILE ERROR"



Selection.Borders(xlDiagonalDown).LineStyle = xlNone
Selection.Borders(xlDiagonalUp).LineStyle = xlNone

With Selection.Borders(xlEdgeLeft)