wrong value

  1. H

    Unable to replace zero date (0/1/1900)

    I have cell with at date that should not exist that is 0/1/1900. I'm trying to find a way in VBA to replace all such values by nothing. I tried : Selection.Replace What:=0, Replacement:="" Selection.Replace What:="0/1/1900", Replacement:="" Selection.Replace What:=Format("0/1/1900"...
  2. O

    Copy table cell and paste as value returns wrong value

    Hi, I have this weird problem that when I copy a cell value in my table and paste it in the same cell as value to get rid of the formula I end up with another value than the one I copied. Specifically, it pastes the value identical to the value on the next row. Example COLUMN HEADER AAA BBB...
  3. H

    Excel 2013 Paste trouble Help me

    I've made some functions with VBA in a Excel file(2013 version) and using it. There was no any problem for the first time. However, after I've added more newly functions and modified them, I've found out there is a big trouble. Here is a situation. 1. A new sheet called 'B' is generated...

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