syntax vba

  1. L

    Explanation of syntax for Workbook_SheetChange?

    Hi all, I'm trying to set up "protection" on my sheets, and so far sheet.protect doesn't do the job, because I have tables and I don't want my users to be able to add columns to the tables but AllowInsertingColumns = False still allows table columns to be added. So I think I have a solution...
  2. C

    Macro Compile Error

    I am writing a macro that will insert a formula in an empty cell that will look at the value in a different cell and based on the last character in the value, enter at different value in the formula cell. It will then copy-down, then copy and paste as values. Below is the code I have written...
  3. D

    print numeric and alphanumeric value

    Hello everyone i have developed to send a email via outlook the code seems to be fine ,but i just have small problem , i have to print numeric and alpha numeric value from the cell but my code doesn't allow to do that, it shows error. the code is working fine when i use alphabets in the cell but...
  4. D

    Asking vba macro excel

    hi all member, My name is Yaman but i use dolphino for user name in this forum,iam from indonesia, until now I work in on of private bank in indonesia, every month I checked the data end of the month for the banking report. I want to use excel macro to simplify my work. Allow me to asking with u...

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