vba & excel 2016

Hello, I'm trying to build a dialog box where will ask me to load a .data file extension file which later on i will edit few things and save as .xlsx. Problem is that whenever the file is selected and supposed to be loaded, there is no outcome... it simply ends macro as if nothing happened...

Hello! I have Googled and searched the forum here, but I haven't been able to find the exact solution I'm looking for. The context of this request is that I'm doing a database update. The source of the records includes addresses, some of which have firm names in them, some of which do not. Our...

Hi team, I have a Macro that runs like a dream on a PC, but on the Mac (which is the computer I use) it does not. I've traced it to the two lines highlighted in red. The macro runs when I remove them, but that means I have to manually close hundreds of files. Is there a workaround or fix for...

Hi All, Please help me solving this error. I have read several post on this error but still I am unable still unable to find solution. This error occurs since below array formula have extended more than 255 char. Please help me how should I break this formula to make my code work. I am using...

Hi guys! Taking my first steps in working with arrays. I'm trying to load a dynamic array as an autofilter criteria, but I must be missing something. Found some hints Googling around, but couldn't make it work. I will get the filter marker in the right column, but no filtering results. Array is...

I'm looking to select the 2nd visible value from autofiltered range. I have a table MyTable and looking to get the value from column G (also named as MyRange). The code snippet below works fine with autofiltered range, but all I can do is locate the first visible value in a column G -...

Good day all, I have a userform with a frame (Frame1) consisting a vertical scroll bar of height set to 1000 , the Frame houses 160 textboxes arranged in 40 rows and 4 columns. The 40 textboxes on the first column each have a list box. The problem is when I double click on the list box...

Hi Everyone, I'm working on a VBA code that refers to a range of cells on my "Summary" page and creates a copy of a hidden "template" tab for each name listed in this range. My question is how can I have the code stop and alert the user of a duplicate name whenever that occurs rather than cause...

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 3 pivot tables using same source data. I have month wise budget and actual numbers (3 columns - Month, Budget, Actual). I have created one slicer for month and only want to show months which have actual numbers(for example Jan to June). Right now, it is showing all the months as budget...

Hello folks; My very first post here...Using Excel 2016 with VBA. I have created some code that will copy specific data based upon certain criteria. I'm not very good at VBA so it may not be the most efficient but I'm 98% there...the criteria works great! I cannot for the life of me paste the...

Hi! I'm using the popular VBA code for range-to-Email functionality. My emailed range includes table with header + a few extra rows below, all belonging to "MyRange". I want to improve the visuals of the emailed range and enabled "Banded rows" under "Table Design". I also considered a different...

I created a spreadsheet that pulls data from various tabs and summarizes it on the main page. Excel then exports the data to a word template. What I would like to do is have the data converted to PDF and attached to an email. Can anyone help me tweak the VBA code I currently have to accomplish...

I am running a macro in excel and i am having trouble with this error popping up and highlighting the Year(DATE) formula in my vba. i have searched and searched and have found things on how to replace the referrences but i dont know what reference to use to solve this issue. my program runs...

Hi everyone, First time posting so apologies if I commit any faux pas. I have a classic problem with vlookup whereas I have multiple matching values but want to get a specific index. I recently got into VBA and wrote a function which does the following: In sheet 1 Looks if cell value is equal...

Hello everyone, my boss has me working on a spreadsheet that pulls information from various tabs into 1 "Summary" tab. We then VBA code to put the information into a table (removing any blank rows in the process) and transfer to a word template called "Proposal" located in the same folder as the...

Hi, I have a spreadsheet I am preparing for my boss that requires me to review column B (B28:B47) on the "Summary" sheet, determine which rows have data and transfer a portion of the rows (columns B, C, D, E & F) to a word template called "Proposal". I have limited experience with VBA but I...

I have worked pretty hard to come up with a solution that does what I had hoped but, it is SLOOOOOW!! Just under 28,000 rows of 8 columns took 19 minutes to process. Not acceptable! LOL! I am summarizing an application log. The process cycle creates three log lines per complete transaction. The...

Hello I need some help to create a VBA code to ; · User enter a End Value · User enter monthly amount · User enters rate (Currently this is hard coded but ideally user should enter it) · Start date I need to calculate interest every June and Dec...

Below, I have an Excel VBA statement that takes 20 MINUTES to complete: Selection.ListObject.QueryTable.Refresh BackgroundQuery:=False Versus, when I right-click the query table in the sheet and manually hit "Refresh" - it only takes 10 SECONDS to complete! What's the deal? Is the VBA...