ctap,
Try...
ActiveCell.Style = "Chaku"
Jim Cone
San Francisco, USA


"cheaperThanAPro" wrote...

The boss is forever telling me how wonderful my computer skills are.
This is so she doesn't have to hire--and pay--people who actually
*know* what they're doing. Sigh.
I am trying to create a subroutine in which a button, when clicked,
will move to a cell, set its style to a previously defined style other
than its current one (called Chaku), and return to the original active
cell. I originally tried to get it to just change the style without
moving the active cell (using Offset within the Range parameter), but I
got a subscript-out-of-range error.
Anyway, the line it's choking on is:
Worksheets("PaymentSheet").Range(ActiveCell).Style .Name =
"Chaku"
I've also tried it with quotes around "Active Cell," but in both cases
I get an application- or user-defined error. What am I doing wrong?
Thanks!
cheaperThanAPro