vba - help

I am trying to do something which I'm sure is an easy task but I can't seem to get the table features correct. Originally, my code deleted columns D, F, and I and then created a table but the table would not copy all the way to the last row. Now, my code shows only eliminating columns D&F and...

Hi All, I have been putting together some VBA to do a mail merge with attachments which is all so far so good - my next thought was to maybe have a sign off button within the email which when pressed a popup will appear asking for a signature which they can do with the mouse. At the moment I...

Hi All, I have a workbook of many pages and a VBA macro to compile data from all sheets (except some other report sheets) Could anyone give this a once over and let me know if they see any glaring errors or opportunities to streamline? Any help would be greatly appreciated! Function...

Hello experts, I need a quick support from experts in this forum. I am in need to create a simple Excel Tool that should have the following: 1) Questions with Answer Options 2) Set of Questions would be under some categories which will have some weightages 3) Each Answer Options will have...

My friend is doing a huge inventory for work. He has thousands of items and an unknown number of duplicates. He wants to create an index sheet with all the different items and counts for each type of item. He wants Excel to "auto-magically" figure out how many different types of items there are...

Can someone let me know if I am taking the best approach? I have a workbook with 24 worksheets, all requiring unique bottom margins and scale settings. I need the users to print and create pdf versions of the worksheets they use with a consistent appearance so I plan to apply a Private Sub for...

I am working on creating a compliance check based on two cell values. I have a "data dump" worksheet where I dump the data from my source. I comes out like below. (it's not code, I just used it to highlight it) Column A...

I don't know VBA much at all.... and I need help. I'm trying to code it so that I can go to the column that I specify in a cell. In cell A5, I have 32. so I want to select the entire column of AF and copy and paste that column to the right, so in this case, column AG. next month, it will be 33...

In TabA <tbody> A B C D Test1@email.com test2@email.com Y Y testb@email.com N Y testc@email.com test4@email.com Y N </tbody> Hello, thank you to anyone who can help. I need to email Columns A-G in TabB to the email addresses in (TabA) column A and (TabA) column B if it has an email...

Hi all, I have 2 codes which I want to use in my workbook. But I don't know how to combine them in to one as I am a complete beginner but have read and now under the impression you can not have to events that are the same. Code 1 Private Sub Workbook_BeforeClose(Cancel As Boolean)...

Hi everyone, All I want to do is to get specific information from a website as a list. Below code works just fine and creates list of daily FX rates. But in holidays (e.g. weekends and christmas) the page does not exist so those days are not listed. It lists only workdays. But I need to list...

I am working on a project that would contain data from multiple sites. On the "Welcome" worksheet (the main page) there is a dropdown menu (form control combo box) that will select a site location (which then prompts a picture of the site to appear) I also want a link to appear that will link...

Still learning VBA but trying to apply it in order to save future time. I'm setting up a program for employees to determine if they are due for a bonus at the end of the month. Our company pays a $100 bonus every month for every employee who has been working with us for over six months. So...

Hi All, This code is getting my really angry at 11:57 at night! Can ANYONE shed any light on this? I don't think the use of my variable within the sheet is correct so potentially that's breaking it. Also, I'm getting a "End If with Block IF" Error message :( Can someone help? 'For each row...

Hi Everyone, Not sure if this can be answered easily but here it goes: I've created a module in VBA where I've placed a sub macro containing: Sub BG_UpdatingOFF() Application.ScreenUpdating = False Application.Calculation = xlCalculationManual End Sub Sub BG_UpdatingON()...

Hey guys, I have a query based on visual basic coding in Excel. I am creating a user form for a piece of work, and there is a certain bit of the coding I am having an issue with. Here is my coding so far below: Private Sub cmdAdd_Click() 'Copy input values to sheet. Dim lRow As Long...

Hi folks! I've got a folder that has 5000+ pdf's in it. I've got a spreadsheet as shown below. I'd like to run a sub that copies the pdf's in the original folder and pastes them into the new folder.. Is anyone able to help? <tbody> PDF Name PDF Type Current Folder Copy to New Folder...

Hi everyone, I'm new to this so please excuse me for anything I have missed out. Basically, I have a pivot table in worksheet "Summary" that I want to copy and then depending on which is easier: • preferably, paste special into all visible worksheets at Cell (A1), • or paste special into all...

Hi I need to create multiple named ranges to use in chart series. Column C contains the name to be used for the named range and Columns D:S contain the data. Some of the rows don't have a complete range of data in D:S so would need to check for blanks. Any help appreciated!

Someone kindly gave me the code below to use. Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Dim LR As Long If Not Intersect(Target, Range(Cells(Target.Row, "A"), Cells(Target.Row, "H"))) Is Nothing Then LR = Sheets("Shopping Cart").Range("B" &...