1. S

    VBA Coding to select cell under Headings when using filter

    I am using a filter to show all "BB" transactions and delete the rest of the rows that are not "BB". Here is what I recorded when I did it: 'Set autofilter on Column E for "BB" and delete all other rows Range("A1").Select Sheets("PPDR_BB").Select Rows("1:1").Select...
  2. S

    VBA Coding for Excel File Path

    Hi, I have prepared a excel template file. i need to put a coding path however the fie can be opened only on my path named. Thanks Santanu
  3. Z

    Add coding to check day of the week

    Hello all, I have a coding that adds appointments to the outlook calendar. The situation is that i have a date in a cell. The coding would then make an appointment 90 days from the date entered. The issue is, what do i add to the coding so in case the 90 days falls on a Saturday or Sunday, it...
  4. C

    Calendar Coding Using Conditional Formula With A Color Code Of Users Choosing

    I'm having trouble learning this "loop" feature in vba, or even if it's the correct way to do what I'm wanting. I'm looking at changing the day's background fill, or the "interior". I figured out how to do it one box at time, but it seems as though that probably isn't the BEST way to do it and...
  5. C

    VBA - Delete rows with certain data

    Hi all, I have some coding that I have developed over time - but I'm stuck at one particular point. In 'column B' I have a list of dates, they are all in the same format (UK). What I want is some coding that deletes any row that has a date from the current year (I'll be using this code going...
  6. T

    please help with vba coding

    Ok, so what i am trying to do is to use a vb form to view ranges on a worksheet. i dont want to change anythin but i do want to scroll through to the last row that has data. that being said, i have literally tried everything i can think of short of just writing a java script and doing what i...
  7. K

    VBA Coding Help please

    Hi I have not done any coding in a very long time but I need to work out how to create a code for the following; I want to enter information on to the first worksheet, then the code to copy and paste the data to the selected hospital and ward entered in the cells on top of the worksheet. Each...
  8. S

    Custom or Conditional Column to Copy data to Null Cells

    I am trying to go through a column (CC) and when it finds a number (such as 120199999), I want power query to copy that number to the "Null" areas above it then find the next number in the column and do the same thing, and so on. In VBA the coding would be: 'Copy cost centres in column A to...
  9. S

    VBA coding help

    Hi all, Below is my coding that helps me search for a word/name in a certain column and return data that relates to this word/name. The values are returned in a neat userform. The only issue I have is that the text I search for may not be unique. There may be 2 or 3 other instances of this...
  10. K

    Code for inserting a row automatically based on a value in a particular cell

    Hi all. I have a spread sheet which is completed using production data. my issue is that when a machine runs more than 1 product only the info. for the one product is collected. What I want to do is enter a figure in column "E", its either going to be 1 or 2. If "2" is entered then I want to...
  11. R

    Personal file not displaying

    My personal file appears in the project window of VBE, and accepts new coding, but the spreadsheet itself does not come onto the monitor. Any suggestions, please?
  12. M

    VBA Coding + Emailing Attachment via Outlook

    So I am fairly new to VBA Coding. Basically what I am trying to do is send my current workbook as an attachment via Outlook and I am wanting to have the subject line of the email be a specified cell range like I want it to be E3+D9. And also when sending the workbook as attachment is there a way...
  13. B

    HELP! Button to Increment a Value in a TextBox

    Good Day Ma'am's and Sir's I am currently trying to make a working system for sales and inventory. I need some help coding for which i have a userform which has 1button and 1textbox, which when you click the button the textbox display a number 1 value, and every time i will click the button the...
  14. A

    How to define this workbook and active workbook

    Hello, i need some coding in VBA which can define this workbook & active workbook in any example. Thanks Amit
  15. J

    Range Reference for an Index

    Hello: The following codes finds the last row in a table and then creates a simple numerical index starting with 1. A couple of things: ==> Is there a way to refer to column C without hard coding it so I can add and remove columns without a problem? ==> Is there a way to refer to cell C7...
  16. S

    macro to copy vba macro

    I was hoping someone might be able to give me some code to help me copy the contents of a macro, i.e. the coding itself, into a text file. The name of the macro can be "module1" for the sake of the argument. Thank you!
  17. S

    Error handlnig

    I have this piece of error coding I've written. Userform18, when called upon, gives some info on how to further handle the error. Because I have hundreds of pieces of "error coding" (each one of them is idential but has a different ### assigned in the "with error codes [xxx]" piece, is it...
  18. S

    Problems with VBA coding to Create Pivot Tables after upgrade to Excel 2016

    I am trying to run all my macros to ensure they work since being upgraded to Office 2016. I am getting a "debug" error whenever the coding is trying to create a pivot table. I even recorded the steps via the macro recorder and it still does not like the coding. Here is the portion of the...
  19. J

    Need HELP with listbox search

    Hi All, I'm very new to VBA I have created a simple UserForm with just TextBox1, ListBox1 and CommandButton1. I have a sheet with data called IngData which has 10 columns and rows will be to how ever fare they will go I have some VBA coding already but my problem is my search results is only...
  20. P

    is there any coding available which puts password after certain period

    Hi guys , I need a solution wherein we are saving a excel sheet & password gets activated after 15 days(for example). idea is to send file to the user & if he doesn't use that within 15 day a pre applied password protect the same & promt for password on 16th day. Regards

Some videos you may like

This Week's Hot Topics