help coding

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  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. 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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top