unexpected event

  1. C

    Range.Delete causes unexpected Click event

    Good, bleary-eyed, morning folks, Today's conundrum is that using Range.Delete(xlUp) is causing unexpected _Click events (two in fact) in a ListBox. I have a named range, "List", covering $A$3:$A$7 which is used in the box's ListFillRange property and as data in the Sub UpdateList. A second...
  2. P

    Formula array in VBA causes subroutine to exit

    Hi, I'm trying to implement to use an array formula to take a value and find the smallest difference from a list of known values. The array formula works fine when I manually input it: ' =MIN(ABS($A$5:$A$502-E5) ' + CTRL-SHIFT-ENTER and when I record this using the macro recorder I get the...
  3. H

    Hyperlink Changes

    Opened a spreadsheet (Excel 2003) I use frequently with numerous hyperlinks in it - almost all pointing to files elsewhere on my C: drive - to find that every hyperlink has been "readdressed" (with the correct filename) to the Excel folder buried in Documents and Settings/Username/Application...

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