vba

So, I have macro-enabled templates for office use. I found a VBA code to KINDA address the problem I was having. Not everyone here is very Excel savvy, so I know they wouldn't be able to remember to save the workbooks as macro-enabled workbook. I found the code for that: Private Sub...

Hi, I am having difficulty with the following data sheets and VBA code i was wondering if anyone could else Essentially what i want to do worksheet 1 - there is variable dates starting from E - BC Worksheet 1 - task items start in range B4 to maximum row 200 Column C is the number of...

Hello, just very interested how to do it , tried everything i knew. Got the next lesson: Set the name of cell B15 to 'criterion1' and the name of cell B18 to 'new'. Assign a validation (input check) to the cell named 'criterion1', which allows you to select one birth month from the list. Write...

I have a single pivot table slicer that contains 39 different last names. When I click on a last name it populates a dashboard with that athletes testing metrics. My goal is to create a VBA code that will loop through all 39 athletes and print individual reports for each to my default printer in...

Hi there, I do a lot of Index Match type of stuff where I'm cross-referencing reports exported from multiple sources, and trying to match account numbers. Some of the account numbers are entirely numeric, while some are alphanumeric, so matching frequently breaks because of the way the data is...

Hi Guys Good to be back I have one sheet which actually a check list for banks KYC/DD documents which is made according to coutnries. Therefore, in one workbook it can have 20 sheet or 19. What i want is VBA to go through the whole sheet compare the today() formula to column J of every sheet...

Hi.... I have made this macro in VBA: Sub ErstattTxt() 'definitions Dim i As Long Dim OldFormula As String Dim OldFormula2 As String Dim NewFormula As String 'loopstart i = 1 'grabbing exsisting formula in active cell OldFormula = ActiveCell.Formula 'Remove the =character in exisiting...

Hi All. I have an MS Office 365 Excel workbook which analyses data and provides charts to show results and "filterable" data. I have buttons for navigation from a dashboard. When I navigate to any sheet for the first time it has parts of the sheet greyed out. If I navigate to another sheet...

Hi Tech, Need help with VBA-generated QR Code based on values in certain cells......................... Series, Firstname, Lastname, Math Grade, Stat Grade, English Grade, Email, Tel, Notification. Thank you

Hi, Please I have this function, which is part of a a Sub macro in VBA, it replaces my old way of filtering, I want to use it as a standalone code for filtering in excel in any active sheet. By just pressing a shortcut like ctrl + w and it works on that sheet. Function FilterX(ws As...

Hi there, I'm having trouble trying to find a way to populate a spreadsheet with data from an external source. Ideally what I'd like to do, is simply "select all" on a browser window that contains report card style information, and then paste it into a blank section of my excel sheet. What will...

Hi, Please I need excel to repeat text in a cell 2x That is REPT(text, 2) IF the text is not repeated, but if it is already repeated 2x, it should not and leave it that way. =IF(B2=REPT(B2,1), B2=REPT(B2,2), B2=B2) It gives me False, then 0 gives me true. Excel formula or VBA would be...

Hello all, I am trying to format series' line color on a graph. However, when I try to reference the names of the series to format the line color I am getting stuck because the names contain a reference to a cell value on that specific sheet. Each SN (serial number) is on a separate sheet in...

I have a macro which works the way i want it to except for this part.. Set rng = ws.UsedRange.Columns(1) .Cells(r, "H") = rng.SpecialCells(xlCellTypeVisible).Count it returns y, instead of x in (x of y records found) this happens after autofiltering with vba.

Hi there I am looking for help on writing some VBA code for the following. I have an entire data tab (titled "paste 1804") I need copied into 2 different tabs with same format, content, etc..: I have Macro push button labeled "Run data Macro", on a tab labeled "Marcos" Source tab to copy...

I recorded a Macro, to get this, but the record can't actually work with returning the value and going to the next row on it's own. I'd really appreciate any help. If this can be done with a Formula or VBA macro, i'd greatly appreciate, thanks. Sub MacroTest () ' ' MacroTest Macro ' 'fileX...

Hi Have a VBA code that loops (Through multiple files) and deletes certain cells but I want to add in a addition to the already named file name. I basically need a code to add into the current one and a code that will just add either numbers or letters to the end of the file name. This is the...

I'm trying to declare a Module level Constant (below). Why does it error? Public Const ps As String = Application.PathSeparator

Hi All, first time posting currently as part of my job I create an excel with many tabs... sometimes as many as 150. I have several questions. Firstly, the tab structure is such that the first 8-10 (this can vary) tabs have specific names from there the sub sequence tabs then follow a...

Hello everyone, Apologies English is not my first language and I am very new to writing VBA codes. So far, I have only copied and adapted parts of the codes to fit my needs. Recently, I have created a workbook, each tab has the name of a treatment site. Daily, I receive data about these...