Proper notation for R1C1 to R2C2 border

[MMEmt]

How do I write the code so that I can put a border around a group of cells using R1C1 notation? What I am trying to do is select 6 cells in a row and put an outside border around them. I have to do R1C1.

Here's the code that I wrote that is failing:

Sheets(newSheetName).Range(("R" & (lRow + 1) & "C" & columnCount), ("R" & lRow + 1 & "C" & columnCount + 5)).BorderAround LineStyle:=xlContinuous, Weight:=xlThick

Thanks,

 

[HaHoBe]

Hi,

maybe use Cells like

With Sheets(newSheetName)
  .Range(.Cells(lRow + 1, columnCount), .Cells(lRow + 1, columnCount + 5)).BorderAround LineStyle:=xlContinuous, Weight:=xlThick
End With

Ciao,
Holger

 

[MMEmt]

Hi,

maybe use Cells like

With Sheets(newSheetName)
  .Range(.Cells(lRow + 1, columnCount), .Cells(lRow + 1, columnCount + 5)).BorderAround LineStyle:=xlContinuous, Weight:=xlThick
End With

Ciao,
Holger

That worked perfectly. Thank you for the assist!