excel 2013 vba macro

Hi. Good day. I would like to repeated loop through a set counter of worksheets and paste the results from each group in a different sheet For example, in this sheet Sample sheet i have 12 sheets with data and 4 other sheets. I would like to skip those first four sheets, copy and combine the...

Hello everybody, I've run into some problems with a worksheet that I'm doing during my internship. The idea is that based on the value of the cell CU2 I wan to hide rows with values greater than the cell value. So if CU2=3 I want to hide the rows 4-9 and so on. The easiset thing is probably to...

I am looking for some assistance with VBA as I am extremely new to this... I have a drop down menu in cells D8:D28 that have 5 options (Elec, Mech, Op, C/Over and Project). I want to stop people selecting either Elec or Mech unless there is a numeric value in cell N8:N28. Please if anyone can...

Hi Friends. I have list of customer information in excel cell ColumnA like list of 1000 customers. I want to extract all phone numbers present in each cell data. But phone numbers formats are different in each cell like 201.337.3900 or 213373900 or 1213373900 or 1(201 337-3900 or (201)...

I have been using API code similar to https://www.mrexcel.com/forum/excel-questions/6148-possible-hide-excel-title-bar.html successfully to hide the Title Bar (min, max, close, menu buttons) in Excel 2013/2016 running Win 7/Win 10 and it has been working without issue on tablets when rotating...

Hello all! I am working on trying to understand how to use this macro I found, the macro places a "MM/DD/YYYY" time stamp in my sheet in column "V" when a value is entered in column "u". What i need is for this to hold true for the dates in columns "X" and "Z" when columns "W" and "Y"...

Hi, I am using EnumClipboardFormats function to go through the clipboard formats. First I copy some data from the cells from newly created Excel spreadsheet. I made a spreadsheet with only EnumClipboardFormats function in it. In this spreadsheet I see various clipboard formats. I have the other...

Hello Forum, As a newcomer to VBA i would like to request your help on resolving the following issue i have: The first Userform ("lvl2Frm") with a combobox pops up after clicking a commandbutton. The user can select a value in the combobox with source...

My company just "upgraded" to office 2013 and now one of my macros that ran perfectly in 2010 now seems to have a handful of issues. 1.It runs at a fraction of the speed ,2010- ~15 seconds per account vs 2013 ~ 1 minute per account.I have already tried disabling Animate controls and elements...

Hi Gurus, I want to find the cells with dates using vba macro. I'm hoping to find dates under column Q which contains dates formatted as "m/d/yyyy hh:mm" and a text "---". After that, the return value is in column B which I plan to use offset function. I just also want to add that I'm a...

Hello All, I created a macro that used to work for a previous project. Now that I have adapted it to a new project, when I run the macro, Excel keeps setting up the problem and the macro does not start running. The code is apparently correct so I was wondering if the problem is: 1. The problem...

I have some software which opens a template workbook. This book has several sheets and each sheet has a different ribbon arrangement. When the sheet changes from one to another, it invalidates the ribbon and forces it to rebuild, using callbacks linked to the particular sheet, giving us the...

I have a VBA macro written (it's at work so I don't have it here) that creates a hyperlink based on a cell value. It is used to call up data related to the cell value. The displayed text is the cell value. It works fine. Next I create a pivot table that includes the column that this data resides...

Hi. Thanks in advance all. I'm running Excel 2013 and I've written a macro to save a .xlsm to .xlsx, and I have a few questions about this. PROBLEM 1: When I run my save as code, I get a dialog which reads, "The following features cannot be saved in macro-free workbooks...