Setting cell borders

[Kevin]

I need to dymnamically set cell borders depending on how
many columns of data are entered by the user. Toward that
end I am trying to use the following:

worksheets(1).range(cells(3,2),cells
(52,curcol).borderaround _
colorindex:=xlautomatic, weight:=xlthick

When this compiles I get an error indicating that an ")"
or list seperator is expected. This is (except for the
range statement in the command) is almost exactly what is
in Help!

What is wrong?

Thanks in advance!

Kevin

 

[Tom Ogilvy]

worksheets(1).range(cells(3,2),cells(52,curcol)).borderaround _
colorindex:=xlautomatic, weight:=xlthick

You need to match the paren in the range

 

[Guest]

try this:
Worksheets(1).Range(Cells(3, 2), Cells(52,
curcol)).BorderAround _
ColorIndex:=xlAutomatic, Weight:=xlThick

 

[Kevin]

Thanks! I must be blind! I thought I checked that!

Kevin