Setting cell borders
 

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

Setting cell borders
 

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

Setting cell borders
 

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
.

Setting cell borders
 

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
.