vba

Hello I'm moving completed tasks from one sheet to another and want to be able to move a task back into my worklist sheet. I have a vba code in Excel for cutting and pasting rows from one sheet to another based on cell value="completed". Now I want to be able to reverse fromthe completed...

Hi there, I would like to use VBA code to highlight the highest values (cell in yellow, font in bold and red) of each row based on B2:G21. May I know how the below VBA can be revised in order to achieve the expected result shown below? Sub Highlight_Max_Values_in_Rows()...

I just discovered that there is some discussion of Word vba here. In Excel, I am used to being able to turn screen updating on and off, and programmatically trigging screen refresh at will. Working with Word vba I have found what should be the appropriate commands; but I cannot make the screen...

Good Day to you all, Newbie here, looking for some advice 😊. I have a spreadsheet linked here (hope it works) Its my works training record for different areas. I could split it down to different positions but I'm sure there's a way to keep it all together. I have browsed through to see if i...

Hi. I need some help with VBA code that should copy value from one cell to another. I have Defined name named ExtractCurrency with formula: =RIGHT(GET.CELL(53,ינואר!$I8),3) It working perfectly with direct formula in the sheet...

I have an excel file that has 3 main sheets. The first sheet is a Table of Contents for different line items (Line Item List). The second sheet is a Summary (0000_Summary). Each Line Item will have its own summary sheet. The third sheet is a Form (0000-01). Each Line Item can have several forms...

I need to compare two sheets (Sheet 1 titled Client, Sheet 2 titled Advisor), each with a table with identical column headers and first column. The first column has the property names, and the additional columns have the information Fields about those properties. I would like the Macro to...

This is the sixth part of this series. The relevant topics are outlined below. The code accepts a different source table which resides in the project sheet and converts it to the required format. Run the tray routine to generate the raw diagram without the connectors. Bring up the user form...

Hi again, I have more troubles with loops. One of these days they will come easier! Each record has a group of tables. I grab these tables (of varied lengths) and put them in Columns A-F (not shown to keep post shorter), this works great. Each record has more tables after clicking a button...

I have read no less than 50+ help articles, watched at least that many tutorials and scrubbed the posts here for any insights, but can't seem to find precisely what I am looking for. I have a spreadsheet tracking issues/tasks (range A7:AZ1005). In cell $Q$1 the user can enter a word to search...

Hi everyone, I hope you are doing well and are getting ready for the weekend. I'm new to VBA and looking to automate the report generation process where for each of the value in criteria range, the macro will paste the value in a filter cell and based on that criterion, excel formulas will...

Hi all, Just need some quick help with a couple of codes I have working almost perfectly. I need comments to stack or add to any comment already in the target cell. I have tried removing the line of code .ClearComments without any luck. I get a 400 error upon running it. Any ideas on a...

Hi! I am attempting to copy some tables from a website. The site is secure so I can't share. I got the table part fine. My problem is there can be 1 or a variable number of tables and to get to them one must click it's corresponding "Show History" . We could have one Button or ten, who knows...

I have a fairly sizeable workbook with a lot of named ranges, many of which are probably redundant which I'd like to delete. It's fairly routine to establish if a named range is used in a Formula or in any part of the VBA code within the workbook, but I can't think of a way to work out if a...

Hello, excel gurus, So, I have a vba code that checks every checkbox that i have in a table, and deletes said checkbox if the row is empty or outside of the table, but I had to put a "+8" in the row range, because the table starts at row 7 of my worksheet. Problem with this, is if someone make...

Hello - I have a sheet full of billing groups and their accounts, with account values and billable amount. In some cases, there is only one account in a billing group, but most of the time, there are multiple accounts within the same group. I'm using VBA to calculate a subtotal of both the...

I am using below code by @Anthony47, which is working fine, now I just want to modify code and instead of copying data in to clipboard I want to save each filtered name as separate image in a folder for that it should ask for destination folder and want to name each image same as the name...

Hi there My question is related to the custom data validation that locks the cell as per the value in the other cell. I have two data columns (G1:G1000 and K1:K1000). My question is, if we enter “Open” in cell range G, then unlock the specific cell in column “K” and open drop down with Yes &...

Hello, I was wondering if there was a way to filter a List (Array/Table/Collection… whatever, i can adapt this) of Custom class instances based on a function of this class. For example, if i Had my class (Person.cls) like this Private name As String Public function IsNamed(filter As String)...

Hi All, I have the code that loops through all my worksheets and resizes all the images but is there anyway to make it so that the images also align center within the cell? Sub ChangeAllPics() Dim s As Shape Dim ws As Worksheet For Each ws In ActiveWorkbook.Sheets For Each s In ws.Shapes...