Hi there,
Can someone show me how to select cells A,B,C with a row variable please I tried this, but of course it doesn't work:
Kind regardsPrintedBoM.Range("A" & i:"C" & i).Borders.Weight = xlThick
Rob
Hi there,
Can someone show me how to select cells A,B,C with a row variable please I tried this, but of course it doesn't work:
Kind regardsPrintedBoM.Range("A" & i:"C" & i).Borders.Weight = xlThick
Rob
Try,
with change in blue, or:PrintedBoM.Range("A" & i & ":C" & i).Borders.Weight = xlThick
PrintedBoM.Range("A" & i).Resize(, 3).Borders.Weight = xlThick
Range("A" & i & ":C" & i)
If you are pleased with a member's answer then use the Star icon to rate it.
Or:
Sub RobK() PrintedBom.Range(Cells(i, "A"), Cells(i, "C")).Borders.Weight = xlThick End Sub
Thanks all, both types work nicely.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks