macro vba

Sub lirebenzing(nf) With Sheets("résultats") k = .Cells(Rows.Count, 1).End(xlUp).Row Open nf For Input As 1 Do Line Input #1, v If v <> "" Then q = Mid(v, 3, 7) If q = "BENZING" Then q =...

Hi, I need help with macro to Automate the following. Column A-D is static data. Column E onwards lists part numbers as comma separated values for different product groups (the amount of columns and rows can vary and so can product group names) I need to achieve the following. Loop/iterate...

Hey, I'm using Pdftk server - a command line tool for multiple tasks like merge pdf, split, rotate and more - PDFtk Server I have a question regarding extracting pdf pages. I created a macro VBA that extract pages from combined pdf and then creates new 2 files as follows: 1- Is my article.pdf...

Hi, I have below macro that calculate StDev and it was working perfectly fine but I got error "unable to get the StDev property of the worksheetfunction class" whenever the I have empty cells. How can I fix this and make it ignore the empty cells and move on with other cells that have data...

Hi all, I'm having a real issue in regards to being able to insert data into a cell which has data validation on it. Basically I have have made a simple data validation rule. Only numbers between 0000000000-99999999999 can be written into the cell (or in column A). I have used Excel function –...

Hi Guys, I have selected DIm Ingrows As Long and set it up as Range ("C2:C" & lngrows & ",D2:D" & lngrows & ",E2:E" & lngrows & ",F2:F" & lngrows & ",G2:G" & lngrows & ",H2:H" & lngrows & ",I2:I" & Ingrows & ",J2:J").Select Selection.Copy some how it does not work :( most probably i am...

Hello, Below is my code which I am working on. It is running but keeps prompting for user windows credentials. Can anyone tell me how to stop that.? Do I need to any line of code to stop asking for credentials or pass credentials through code. Sub testit() Set shFirstQtr =...

I was able to get my macro to work with the code below and then I was asked to tweak a little and now I'm having problems again. Assistance on the tweaks to my code is greatly appreciated. The tweaks I am to add: 1) Add a keyboard shortcut. However, when I do this, the macro stops running at...

I have a worksheet consisting of approximately 50,000 rows and 30 columns (A - AD). Each column has a heading. I need a macro that will quickly delete all rows that don't contain specific text in Column C. Column C will have names of schools, elementary, middle, and high. There are approximately...

I have 2 columns A1,B1 A1 is a name B1 is a number . But not every B column will have a number only if A column bought something that month. Example A and B columns Frodo 10 Gandalf 5 Sam Merry 5 I need help with a macro that will copy only the row with a number in B...

In my Excel sheet there are ABCDE columns D column is filled in with data. & I am filling down BCE columns by selecting & Pressing CTRL+D. I want a VBA macro to do this, the sheet is of 1000 rows. data looks like this I want the data to be like this

this code is written to update the shape of the color whenever i drag n drop it according to its position. it is called once in workbook_open() event But it is running all the time from opening the workbook till closing it. Is there any method to make it run only when shape is selected. Sub...

I have created an automated macro which takes vehicle crash data from a csv file and automatically creates pivot table,charts and compares it to the previous year. The code is approximately 1400 lines long and the data of the uploaded csv can be anywhere between 2 to 100 mb csv files with more...

Aloe all, here is my issue: When we print an invoicing worksheet, we adjust the page breaks depending on how many days/shifts we need to cover and we reuse the same workbook as a template for the next one. So, if someone was using one that covered 7 days and the next one only covered 1 and they...

Hi all, I know this has come across couple of times and I tried to find a formula that will count the consecutive blanks in a row (a month's roster). I can't work out the formula solution so I wonder if there could be a macro (I know nothing about VBAs etc) to do so? Basically, the roster may...

Hi there, I was wondering if anyone out there might be able to help me, I am looking for a way to take all rows from a spreadsheet where the value in column U is 'closed' and transfer them automatically to a different worksheet. I discovered the world of Macro and VBA today and have been quite...

Let’s say we have data (not with 24 weeks) but with 1000 weeks <TABLE style="WIDTH: 293.85pt; BORDER-COLLAPSE: collapse; MARGIN-LEFT: 2.9pt" border=0 cellSpacing=0 cellPadding=0 width=392><TBODY><TR style="HEIGHT: 15pt"><TD style="PADDING-BOTTOM: 0cm; PADDING-LEFT: 3.5pt; WIDTH: 48pt...

Hi to the experts, Using VBA statements from other macros I tried to make the following macro. The function is to make a new worksheet with data from a large sheet(the database). The user is asked to give a date. This is the startdate for the selection, the enddate is always 10 days later...

Is there a way have a macro working on one worksheet (in the background) while I am manually working on another?

Hi, I need to calculate formula in sheet1 taking values from others sheets. For example I have a formula in sheet1 containing the cell A1 of others sheets (sheet2,sheet3,sheet4 only). If i remove any one sheet (ex. sheet3), then the formula should work taking remaining sheets (ie., sheet2...