excel 2016 vba

Dear Excel VBA Experts, I am an intermediate VBA "coder" and I have two working procedures which I need to combine into 1 procedure and after hours of trying I decided to come here for help. I hope that someone can help me! I have a workbook "MyWebScraping.xlsm" which has 4 sheets...

Hello Gurus, Good day! Could you possibly help me tweak below code? I have multiple workbooks and need to combine into one. I have below code that can do it. However, I am getting an error message whenever there is same tab name that exists on different workbook. Note that the tab name most...

Hi, I have looked around the net, but I can't find a clear answer for the following. also a linked to excel is attached at the bottom I would like a VBA code that can fill up the cells, and continues filling not start from the begging so it is based on the current date for example if the...

Hi All, This is my first time, trying to work with a recorded MACRO in EXCEL 2016 I have two workbooks: A & B. Workbook A - Has data, Is editable, with 3 sheets. Workbook B - Has 100 forms/sheets that are protected, can only paste data into the form, doesn't show me the Sheet number. I have...

<button title="This question does not show any research effort; it is unclear or not useful" class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" aria-pressed="false" style="background-attachment: scroll; background-clip: border-box; background-color: transparent; background-image...

Hi, if i use the current syntax with this macro i get an annoying "clipboard has a lot of info on it" popup. To avoid it i would like to use the non paste method, but i cant figure out the appropriate syntax for the situation. Thanks for any help. This is the code section in question...

Greetings my fellow Excel enthusiasts, I am hoping someone here can help me develop a code that will export data from excel to a word template, generate a report/proposal and attach it to an email in a pdf format. I already have the code to generate the proposal but can't seem to figure out the...

I have upgraded to Excel 2016 from excel 97/2003. I have several workbooks with macros in the old format. When I attempt to save them to the .xlsm file format, I receive a message stating that: "This workbook contains one or more of the following features that are not supported by the...

Currently I have a workbook that my end users fill out and submit to make changes to spare part info. When I receive the workbook I transfer the data to a repository file that is used as a search tool. Currently the repository file can be accessed by my end users, but some of them make changes...

Hi, Can anyone help with the following? I have some code below that doesn't seem to work. My first question is why? and my second question is- is there a better way of solving this problem as the client seems to alternate between values for 'Forename' eg 'Firstname', 'First name'...

I am trying to create a macro that will highlight cells already selected. Below is the code I used but that is only working for the active cell. How can I alter the code to highlight all the cells I selected. Example: Cell C15 is the active cell and cells C15:C20 are selected. When I run my...

'My code is running through without error all the way to Msgbox. However the values are cleared from "WbRevDash" workbook and new values are not pasted in. The ranges are just blank. Any suggestions are helpful! i think it has to do with this part of the code but im a rookie and rely on the...

I'm quite a rookie when it comes to programming, however I have been able to build a couple of useful applications in excel, which automate some of my everyday tasks. Currently I am having an annoying issue when trying to open a new workbook using <code>workbooks.open()</code> in Excel...

I have a workbook that I only want certain users to be able to open. I have a list of network usernames that should have access on a worksheet called "LISTS". The list of usernames is in column "M" (range M2:M159) that has a dataname of "usernames". How do I set up some VBA code to look at...

I currently have a workbook that employs userforms that my end users fill out to send in part maintenance requests. Once we receive the workbooks from the end users I process their requests into out SAP system. Once I process the data, I have to click the email icon in my quick reference bar to...

My workbook uses userforms to create a new row in a three different table on three different worksheet in the same workbook. I have a listbox (LB_01) on the userform, but am not sure how to get the new data submitted from the userform to post in the listbox since I am using one userform to...

I have some code that creates a new line in 3 different tables on three different worksheets in a workbook when data submitted through a user-form. All of the formulae are copied from the line above and all of the data from the user-form writes to the correct locations, but I have a total of 5...

I recently got my VBA code working to create a new row in my tables without overwriting data in the line below. The issue I am having is there are some cells in my workbook that have formulae and some have conditional formatting that the new table row needs to inherit from the line above when...

I have set up some command buttons that open user-forms for my end users to enter data into in order to update tabs in the workbook. I have set up three tables, one in each of the three tabs. The problem is, in two of the three tables a new line is not being created in the table. It just...

I have a large workbook with many worksheets within it. The end users fill in the user-forms and email the workbook back to me. There is a "SUBMIT" button in the workbook that uses VBA code to transfers the data submitted to another workbook that is used as a repository. I do not have any...