locals

  1. T

    Number formatting in arrays

    In Excel, I have 3 numbers in cells A1 through to A3. These are: 1, 2 and 12345678901234567890 If column A was formatted as a number, it will show as: 1, 2 and 12345678901234500000 The reason is Excel truncates long numbers. When I look at the Locals Windows when running this code...
  2. K

    missing locals window

    In VBA when I try to view the Locals window, I can't find it. Is there a way to reset the location, or to identify the location of a particular window in the Immediate pane? I am thinking it might be docked somewhere I can't find it, or buried in another window; but I really want to get it...
  3. K

    cannot view workbook information in locals window

    I put in the code: Dim wb As Workbook, str1 As String Set wb = ActiveWorkbook And when I look at the info for wb in the locals window for wb it just as no variables. I'm pretty sure that it was working a second ago.

Watch MrExcel Video

This Week's Hot Topics

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
Top