ucasetarget.value

  1. I

    Expand on current code in use

    Hi, Supplied is the current code in use. I wish to expand the code to apply a number in the corresponding cell in column E Target cells are currently in column D "name of shop" & now wish to also add in column E "mileage to that shop" Currently if i enter 1 in the target cell i then see...
  2. I

    Code lags when run

    Hi, On my worksheet called G EXPENSES i have the following code in use but when i leave the cell i dont see the name appear straight away but more like 2 seconds later. Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("D5:D35")) Is Nothing Then If...
  3. T

    Macro works in 2000 but not in 2016

    I have a script that I have used for years with Excel 2000 for conditional formatting since in that version you were limited to 3 choices. On one of the computers we updated to Excel 2016 and the script no longer works. If you type a letter in a cell, for instance F or f, the script will...
  4. I

    Edit to current working code is needed please

    Morning all, Can you advise how i would go about the following request please. Each day i would enter data into my worksheet. The cells in question are always the same. The cell the data is entered into is A17 As i leave this cell in question i would like some code to look at the 10th character...

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