try this
Sub Comment_To_Content() 'pastes the comments in a range as cell
'contents in another range
Dim C As Range 'the selected range
Dim UserRng As Range ' the receiving range
Dim dest As Long, RwNum As Long
Dim content As Variant, response As Variant
'PRELIMINARIES
Dim
I have code which does this:
Color_A as long, Color_B as long
Color_A=RGB(186,85,211)
..
activecell.interior.color=RGB(186,85,211)
Color_B=activecell.interior.color
The result is
Color_A = 13850042
but
Color_B = 16751052
Can anyone explain? Is there a workaround?
--
--
The button in the dialogue box you get when you go down the path of
Tools
Options
"Error Checking" tab
On Jan 20, 6:37 am, OE
wrote:
> Using Excel 2003
>
> How do I programatically toggle this button. I can't find any
> documentation and the macro recorder doesn&#
Using Excel 2003
How do I programatically toggle this button. I can't find any
documentation and the macro recorder doesn't log the action.
thanks
--
--
Some important links for excel users:
1. Follow us on TWITTER f
