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
|