help coding

  1. H

    How can I code VBA with named table

    Hi, I'm trying to create a league tournament for a 10 deck vs. 10 deck card game. For each victory I fix the score of the duel and click on a button to launch the macro which will implement the different tables. I name my tables with the name of the decks. My question: I have 2 dropdown menus...
  2. T

    Make blank cell actually blank....

    I can't figure this out. The code all works as required however... when referance "Lalllo" is pasted into range "I32" the blanks it pastes are not actual blanks in terms of what sub Clearvar is doing I get error message 1004 no cells were found. If I then manually click on each blank cell and...
  3. A

    Autofill Formula in next line

    Hi ive been working on a VBA project (Note: im still a novice and google everything I need to know) Ive developed a userform to capture some employee details and in the process to calculate the days to expiration of set dates against every new employee... The sting that I use are as follow...
  4. G

    Multi user login with diffrent rights

    hey! I have a multi user workbook i would like to ask for some help. I have crated a login sheet where i can write user id and password for this workbook. I have then crated a loop to make it look for the user if it match you get access. This is where i am stuck i cant get it to give different...
  5. A

    VBA Code Username/Time/Date/Sheets Stamp Shared Workbook With Macro Buttons

    Hi guys, Hoping forsome guidance on how I can achieve a log of activity to be automatically generatedwithin a shared workbook. Currently I have a functioning code for a single userbut I don’t think it can work for multiple users looking at the workbook at thesame time. Presently,the below...
  6. T

    VBA Help How to transfer column to an array in order to search and replace as quick as possible

    Below is a macro that stores the search items in an array and replaces with nothing. I couldn't include <P style*> in this array because it is replaced with a value. Unfortunately this bumps the completion time back up to how long it takes with a manually recorded macro. It was suggested to me...
  7. P

    VBA IF statment

    hello, I 'm really knew to VBA coding, and I was wondering if you guys could help. So I was wondering if anyone could help me with this code. I'm trying to make the if statement code for VBA, it can be either sub or function. ok so I'm trying to make if statement that says; " if active cell...
  8. P

    VBA IF statment

    hello, I 'm really knew to VBA coding, and I was wondering if you guys could help. So I was wondering if anyone could help me with this code. I'm trying to make the if statement code for VBA, it can be either sub or function. ok so I'm trying to make if statement that says; " if active cell...
  9. M

    VBA Code Needed For Word to Excel

    Hello all, Excel 2013 & Word 2013. I have a directory full of .doc files. Let's call it C:\BOM. I will generate a .txt file of certain files from that directory and save it as C:\BOM\BOM.txt. Example: BOM.txtC:\BOM\file01.doc C:\BOM\file05.doc C:\BOM\file11.doc C:\BOM\file47.doc I need an...

Watch MrExcel Video

This Week's Hot Topics

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
Top