vba - help

Hello, I am trying to run simple macro but I get this error: VBA Run-time error '-2147417848 (80010108)': Method 'Range' of object '_Worksheet' failed My procedure is following: Sub Fill_Empty_Cells_with_Formulas() Application.ScreenUpdating = False Dim rng As Range Dim i As Long...

Hi Guys, I was wondering if anyone can help me as I dont know if this is possible. I was wondering if anyone knows can use VBA to : 1. Copies values from Sheet 1 A1,A2,A3,B1,B2,B3,C1,C2,C3 into E11:E14 2. Then Copies this range E11:E14 into Sheet 2 A1:L1000 3. But each time it did copy...

Hi All, I need to create a VBA code to execute the following task: Current scenario - In Sheet1, I have data in column Z to column AQ 3 columns starting Column Z forms 1 set, i.e. Col Z, AA, AB is one set; AC, AD, AE will be set 2 and so on (total 6 sets). Data in one set has to be copy...

Hello everyone. I'm interested in trying to automate two process that we run each month: 1) rolling forward reconciliations (tabs) and 2) rolling forward schedules (workbooks). And I wanted to see if anyone has created VBA to accomplish these tasks. 1) Rolling forward reconciliations. Each...

Hello all, I'm having trouble with a small micro running much slower than I believe it should. Please see the code bellow. Sub NBill_Click() Dim NBill As Integer NBill = MsgBox("This action will update the previous percent complete and the total billed to date?", _ vbOKCancel, "NEW...

Good Afternoon, I was wondering if anyone could help me. I have searched the forum and I can find posts regarding positioning text boxes on Powerpoint using VBA, however none relating to what I was after. I am working on price maps and I have used a VBA so that I can update the price boxes...

Hello All, I'm still very new to vba, pardon my misgivings! I was wondering how to modify this code if I wanted to add a running total of column A on column B rows every time I add a value on column A. P.S. I'm tucking this to a user-form button. <tbody> A B C 1 Coin Total Demand 2 2...

Good morning and thanks in advance for your help. A little information on what I'm trying to accomplish first. I have a reports where the cost center name is located in the title in cell $A$3 as "00-100 G&A". Throughout the remaining rows in column A the cost center name is repeated as...

Hello...new user...limited knowledge of VBA. Here's my question...I have a macro started like this: Range("S5").Select ActiveCell.Value = ActiveCell.Value + 1 Range("U5").Select ActiveCell.Value = ActiveCell.Value + 1 Range("M2").Select If H1 = 1 Then ActiveCell.Value =...

Hi everyone I'm trying to get this to work but I just don't have a lot of experience with VBA. What I'm trying to do is to get data from "sheet3", columns 1, 2 and 5 and paste them on the "summary" sheet starting at row A7. The workbook that I'm working with has 37 sheets, 35 of those sheets...

So a have code written in tab 'sheet1'. And Basically if the tab becomes hidden, I want the word 'No' written in the tab 'info'. And when the tab becomes unhidden, I want the word 'Yes' written in the tab 'info'. At the moment, when i unhide/hide 'sheet1' nothing happens. Private Sub...

I have a two sets of data from two different subsidiaries that serve the same market. The newer subsidiary "bought" customers from the old one, but the old subsidiary still services the market with those products that still remain outside of the capability of the new subsidiary. Easy, right...

I'm wonder if there is a macro out there or that can be written that changes the values of the existing series of a chart? I have 28 charts and each chart has multiple series in them. I have created dynamic name ranges for all of the series y values and the series x value is the same dynamic...

Set OutLookApp = CreateObject("OutLook.application") Set OutLookMailItem = OutLookApp.CreateItem(0) With OutLookMailItem For iCounter = 6 To WorksheetFunction.CountA(Columns(4)) MailDest = "" If MailDest = "" And Cells(iCounter, 4).Offset(0, -1) = "Send Reminder" Then MailDest = Cells(iCounter...

Hi Guys, I am using the below code to search for a range like "B29:D36" and for the values in this range to be taken from the "lenses" sheet to the "menu" Sheet. I had it working when I was just looking for this one range but when I increased the amount of criteria instead of it not working...

Hello, Currently i run a weekly report that drags in the past weeks breakdowns and i am trying to find a way to delete a whole row of cells if the time is before 8AM. I have had a number of attempts but i cant get anything to work; Sub DeleteRows() Dim i As Long With Sheets("12 hr Nights") '...

Hi all, Before this, i just get the number for the info that i want, like right now i need the information in column itself. Formula that i used to get the data =COUNTIF(Q:Q,"*"&Apple&"*") so i got 2. I would like to get the output Like "Apple = Apple-Lemon, Papaya-Apple." Means that, find all...

Hello! I have been working on this issue all day, so I am hoping someone here is able to help. I am trying to create a VBA script that will allow me to easily complete a copy > paste special (transpose) operation. 1. I need to select a custom range of data 2. Loop through the data by row 2.1...

Hi Guys, I am just experimenting and trying to learn VBA. I was just wondering if anyone knew the VBA Code for: IF Range "A" Exceeds "X" Value Then Move To Sheet A Thank you.

Hi all, I am new to vba and i have tried to find a code on here for clearing my whole worksheet but i cant seem to find one which does the specifics i want to or does all the bits :) if i missed something id be very grateful for a thread link... Trying to create a new prf for my team, and i...