Most valuable professional
  • Hot Topics

Excel Border active cell range

Hi I have the following code, that works excellent for the workbook, however I would like to limit it to only the "active page" and cannot seem to get it, can anyone suggest a way. For Each ws In ActiveWorkbook.Worksheets LastRow = ws.Range("A" & ws.Rows.Count).End(xlUp).Row ws.Range("A7:F" & LastRow).Borders.Weight = xlThin Next ws

This question generated 10 answers. To proceed to the answers, click here.

This thread is current as of September 14, 2014.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel