coding

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...

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

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...

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...

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...

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...

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...

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...

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...

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...

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?

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...

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...

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

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...

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!

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...

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...

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...

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