named constant

  1. G

    Named Constants w/ VBA

    Hi - I've created a Name using the 'Name Manager' and called it 'User'. The name is a Named Constant, so it doesn't refer to a range on the spreadsheet. In the 'Refers To' dialog box it has: ="GRC" When I try to refer to this in VBA, I would expect to get GRC but what I'm getting is...
  2. R

    Trick to escape 255 char limitation of Range.FormulaArray property

    I was in the process of figuring out some trick to make range's FormulaArray property accept strings >255 chars. Along the way in the interwebs, I came across a link which stated one can indirectly accomplish that by setting a named constant with a value >255 chars (this is apparently possible...
  3. R

    VBA change value of named constant

    I'm new to vba but trying to learn. I'm stuck on changing the value of a named range. Any ideas for a beginner? Sub test() If [Toggle1] = 1 Then [Toggle1] = 0 Else [Toggle1] = 1 Select Case [Toggle1] Case Is = 1 Sheet2.Visible = True...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top