.BorderAround

[dinotom]

with rngCDTemp being set to a range (a valid range )

why does this bolded line produce an error (trying to put a thin line border around the whole range)

 With rngCDTemp.Select
        [B].BorderAround.Weight = xlThin[/B]
        ActiveWorkbook.Names.Add Name:=AcctName & "ChtDataTable", _
        RefersTo:=rngCDTemp
     End With

 

[Norie]

Thomas

I'm getting increasingly confused, and it's not just an age thing.

The code I posted worked.

If similar code doesn't work for you then you need to post that code, it could be a problem with the range.

But that's kind of hard to determine without seeing how it has been created/referred to in earlier code.

I also don't understand what you are saying about using With.

Sure you could do something along those lines but you would have to actually reference the object the With is associated to.

And you aren't doing that in the code you've posted.

 

[dinotom]

Thanks to all for the help