ocol

  1. N

    Vba help

    I am getting debug error in (Set myRng = .Range(myCopy)) Sub UpdateLogWorksheet() Dim warning As Integer warning = MsgBox("Data Updated Cannot be Modified", vbYesNo + vbQuestion, "NOTE") If warning = vbYes Then Application.ScreenUpdating = False Sheets("Database").Visible...
  2. E

    One input form that updates two worksheets

    Current using excel 2016 home version. I am looking for VBA that will update two separate worksheets (customers & cars) using 1 worksheet (input). I am new at this so I started by doing one worksheet. I found the code below and modified it and it works fine, but now I am struggling with two...
  3. D

    VBA Command Error - Beginner's Advice

    Hi, I am using a template for a data entry form that I found online and have added some additional fields. Since adding the new fields I am getting the following error: "Run-time error '1004' Method 'Range' of object_Worksheet failed. Below is my code. Can anyone identify the issue? Sub...

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