I'm trying to extract the Compression attribute from several thousand jpeg files. How can I do this with either Excel VBA or PowerShell (or some othe...

To clarify, say we have data like this (except column sku & image are several 1000 in length): Matching A2 to B2 is easy, but not so much when upload...

im have Problem and i hope u can help me :) I really confused about this problem, because i dont how i can do that, i search on google and i cant foun...

So I am creating a worksheet that requires a cell to return the text "CLOSED" if another cell has text "MAINTENANCE". At first glance I tried using =i...

I have this in my code: Dim cYear() As Variant I am not so sure what to code next. Should it be like this: cYear = Array("2023","2024","2025") or cYea...

I am trying to rename a set of pdf filenames in the form: "Joe BLOGGS_3052023.pdf" or "Joe BLOGGS_31052023.pdf" ("FirstName SURNAME_dmmyy" or "FirstNa...

Here is the code I used (triggered by a button on the "Sorts" worksheet): Sub EOS_Archive_2() Dim LCopyRow As Long Dim LDistRow As Long LCopyRow = W...

EDIT I think I might have alongated too much tryin to explain, and I will post a shorter version, cuz I figure it out it might get easier to understa...

Thank you in advance for reading my question.😀 I'm looking for a way to print the exact information on both sides of name badges. I have a data base ...

I need a script that cycles through all the sheets in a workbook and adds 2 (or more) columns at the end of the table of each sheet (except the first ...

I have this code. I want that it does not delete 3 pictures which are named, pic__Flag, pic__Building and pic__Logo. These pictures are inserted with ...

The number of ways to simply copy a row in a worksheet to another worksheet is bewildering, as is the number of parameters required to specify it. Eve...

I found this code online, but I believe the original purpose was to export as some other file. Regardless, I want this code to export the excel sheet ...

I would like to enable custom tabs based on the activated sheets. So I have an event macro at the workbook level. Private Sub Workbook_SheetActivate(B...

I have 2 workbooks, one source workbook with data spread over different sheets, and one target workbook where this data needs to be copied to, on one ...

I was trying to copy merged rows to another workbook single cell using Macro. Does anyone knows any code snippet as reference please. Thanks. Source t...

I am running this block of code that looks for product quantities in column M and if the quantity is greater than 1 it inserts a row beneath that valu...

I am currently trying to format a block of code someone gave me in a comment on a previous question but have been getting a lot of compile errors. The...

I have a Time In and Time Out buttons in a form. And I have a VBA Module code that saves the last entered data/last row of an entry from an Excel Tabl...

I want to alter this VBA so that it concatenates the range of A2:A200 but rather than inputting the result into the specified C1 cell, it will instead...

I am trying to concatenate the range A2:A200, separated by " OR ", but have the VBA stop once it reaches a blank cell. How do I adjust the VBA I am us...

I have this code which helps me to copy paste information from one workbook to another. The values get pasted with format and formulas, but I want to ...

Is there a way I can use VBA to search any of the rows in column A for the letter Q and if letter Q is the first letter in that row than the code woul...

After seeing this post I was wondering what's the best way to remove trailing zeros in a cell with VBA. By the best way I mean the shortest line of co...

My question is now answered. I have selected several cells in excel, e.g. Range("B3:F6"). Running the following code, that I copied from the answer be...