allowevents

  1. I

    Code to work to specific row and not whole row

    Afternoon, Working code in use shown below. Currently this code operates the whole of column B where i would like it to stop at the last row. So currently my last row with data in is row 19 BUT then i also see the message if i type in row 369 where at present its empty. Basically find last row...
  2. I

    Deleting row changes font color advice please

    Hi, I am using this working code shown below, It works like this. I complete each cell in my new row. In cell B7 i enter 17 characters,the 10th character is shown in a red font. Cell E has a date automatically entered due to this 10th character. If for any reason i decide to delete row 7 at a...
  3. I

    If Then code advice please for existing working code

    Evening, I am using the code shown below. I need to add a small piece of come to it if you can advise please. Basically you type a value in cell B7 & a date is also then entered into cell E7 Ive noticed that should you delete the value in cell B7 the date in cell E7 is still present. So how...
  4. I

    Advice for adding line of code to existing code please

    Hi, I am using the code below which works fine. Private Sub Worksheet_Change(ByVal Target As Range) Dim c As Range On Error GoTo AllowEvents If Target.Count > 1000 Then Exit Sub If Not Intersect(Target, Range("B:B")) Is Nothing Then For Each c In Target If c.Row > 5 And...

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