application.undo

  1. H

    Debug error

    My spreadsheet takes totals and subtracts totals. I have about 6 columns and rows that are filled with data. If I try to insert a new row I get a debug error. The debug highlights "Application.Undo" Not sure why any suggestions? Private Sub Worksheet_Change(ByVal Target As Range) 'copies the...
    • hopr37
    • Thread
    • application.undo debug dim integer newvalues
    • Replies: 25
    • Forum: Excel Questions
  2. J

    Application.Undo Error

    I am attempting to write a function that does not allow users to copy text into a forced data validation. For some reason I am receiving an Application.Undo error? Can anyone provide guidance? Thanks. Private Sub Worksheet_Change(ByVal Target As Range) 'Does the validation range still have...
  3. V

    Application.Undo not working properly!!!

    i have form for change case.. it contains RefEdit control , option button, command button.... 1. by using RefEdit control I'm selecting Range.. 2. Option button is for selecting Upper Case.. 3. On click on command button the selected range value is change to Upper Case.. this is working fine...
  4. M

    Application.undo only works if I commit cell changes by selecting another cell with the mouse

    I have been trying to get application.undo function to work in a simple worksheet_change event macro as follows: private sub worksheet_change(byval Target as range) Application.enableevents = false Application.undo Application.enableevents = true end sub By rights this should undo...

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