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

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

You need to match the paren in the range

--
Regards,
Tom Ogilvy

"Kevin" wrote in message
...
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

try this:
Worksheets(1).Range(Cells(3, 2), Cells(52,
curcol)).BorderAround _
ColorIndex:=xlAutomatic, Weight:=xlThick
-----Original Message-----
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
.

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

Kevin
-----Original Message-----
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
.