excel 2010 vba

Hello. Trying to explain to myself VBA. I got the anatomy of this code in order to understand How to change or manipulate the for loop results any way I need, so what I learn from here is: Cells(Rw, "H").Value = Cells(Rw, "H").Value + Cells(Rw, Cl).Value with this line I can get my result on...

Using VBA code in Excel 2010 file. I have a data set with about 300 records. I need to send emails (using Outlook) to email addresses from two columns in the Excel file. The email will have a preset Subject and text that goes in the body of the email. In addition to the text in the body, I...

Please review my code (Very new to VBA) and let me know why i get 2 copies of the first print then the rest come out ok with a single printed copy? I have created a Print command button and this is the associated code. [Private Sub PrintAll_Click() Dim rngOffenders As Range Set...

Hi Guys, I hope everyone is good today :) I was just wondering if anyone knew the VBA syntax a Sub that would ask the user if they have finished using a message box then if yes clear a range of cells say A1:D4 then save and close the spreadsheet and if no allow them to continue. any help is...

I have been using this macro now for years and for some reason today is starting to throw this error. The macro takes a workbook and creates a new workbook for each worksheet, runs the macro "Customer Invoice" to format the file and then saves the file as the name of the worksheet plus the...

Hello, I have an Access database that updates weekly. I am trying to run an Excel macro triggered by the completion of the database update (in this case, I want the excel sheet to Refresh after access updates). I have very little Access experience (someone else set it up). Any help with...

Excel 2010, VBA, Windows 7. intermediate VBA experience. I have a large spreadsheet that generates other spreadsheets from downloaded data. I am trying to optimize the coding so as not to keep repeating the same formatting code for multiple columns, for example. Kindly responses to prior posts...

How to count cells with a particular data and change the cell data when a predefined limit is reached I am in the process of making an attendance sheet for work . for which i take mobile number and the date as inputs and mark "P" for presence. if all is well the presence is marked as "P" else...

Good morning, I am trying to create a heat map of the US that changes the shade of each state based on the values in another table range (B1:F45). There are 6 "tiers" of shade for each range of values: <colgroup><col><col></colgroup><tbody> 0 RGB(255,255,255) 1-140 RGB(235,241,222)...

Hi I'm creating multiple choice test and i have everything done apart from the answer data validation. The problem is the questions are from a question bank of around 40 which 10 are randomly chosen and i cant figure how to create a dynamic data validation. Main sheet table <tbody>...

How can I replace the sheet name with a passed through named variable? MasterWB.Names("HC_Results").RefersToR1C1 = _ "=OFFSET(Results!R1C1,0,0,COUNTA(Results!C1),COUNTA(Results:Results!R1))" Does't work when I just do this: MasterWB.Names("HC_" & wsR & "").RefersToR1C1 = _...

I have a spreadsheet that populates itself from individual stock data downloaded and subsequently calculated. The data is sorted per Sector Category - each sector may have one or more than one hundred tickers within it. With the excellent help from those on this forum I have been able to get the...

I have some simple VBA that highlights the entire row if fields in a column match a certain criteria, however, I would now like the VBA to look at the cells in another column that have been highlighted and delete the row if the cell contains the same value above or below. See example below, rows...

Hello, I'm playing around with creating a userform in Excel 2010 (under Windows 7). I have set the form's width to 250 (and the position is set to Left=0 and Top=0). I then added a frame to the form and set its width to 240. Now, the arithmetic would tell me that setting the "Left" value of the...

Hello, and thanks in advance. Every day I get emailed a table in HTML format. Copy and paste works, but I was wondering if anybody had any clever ideas on how to get excel to do this on its own? The email comes from the same address and the table is 6Rx7C including headers. Thanks for looking!

I have written a VBA procedure in Excel 2010 that tries to hidden commandbars and prevents several actions from the user. I have included and run this code: Dim Cbar As CommandBar For Each Cbar In Application.CommandBars Cbar.Enabled = False Next Now, when I opn ANY excel...

Hi! Is there any other way to check if file exist without using dir$() function? any help i appreciated thanks in advance

My company has authorized me to update our spreadsheets and included VBA macros to Excel 2010 from Excel 2000. The short version of my question is: What is the best reference for help in formulating a plan for the VBA conversion process so I can avoid some of the Trial and Error process...

Hello all, I have a list of data in Column A in Sheet 1, and in Sheet 2 I have 1000s of rows where that data may appear once, multiple times, or not at all. I would like to delete all rows NOT containing the data in Column A from Sheet 2. How can I do this? Let me know if you need more...

Excel 2010 VBA In order to make the code below run faster, I set the Application to manually calculate formulas. At the end of the code, I turn it back to automatic. However, in the status bar on the spreadsheet it still shows "Ready Calculate". When I hover over "Calculate" is says...