insert

Previously I had similar problem with this one, where I needed to assign a value to array's element then use ARRAYTOTEXT function. The reason I use arraytotext function is because I need to do iteration involving dynamic array variables, so I store the arrays in some cells in a row for each...

Hi I've been working on that code with GPT usage. I tried to find the solution but any change to the code doesn't let me insert photo to a cell. The photo is floating on the sheet Sub SelectSheetAndPasteValue() Dim sheet As Worksheet Dim selectedSheet As String Dim employeeNumber As...

Hi all, I currently have this graph: I don't really care about the light and dark orange columns, but I need them to stay nonetheless. However, the grey chart rises from a value of about 9300 to 10500 doing this period, which is not that noticeable in this chart to be honest. I would like...

Hi, I apologize if this question has been answered but I wasn't able to locate the thread. What I am trying to do is insert a formula that looks at the adjacent cell to see if the text includes "-Ann" or "-SANN" and then enter ABCD or EFGH in the adjacent cell. So if column B includes...

Hello, I have a workbook that was previously working with no issues. Recently, however, I have been having a problem with adding/deleting columns on visible sheets after I run certain macros. The workbook is used for groups of members. When data is imported into the file a base number of...

Hello. I need a macro that I have no idea how to even start making. I have multiple images in multiple subfolders. The file structure looks like this: /Excel_file.xlsm /Images/Object1/Image1-1.jpg /Images/Object1/Image1-2.jpg [...] /Images/Object2/Image2-1.jpg /Images/Object2/Image2-2.jpg [...]...

Hello, I have a problem with comment options in excel 2016. My idea is to add an excel file in Sharepoint page (shared with group of people) and to insert and reply a comments. I can only insert and edit a comment, but can`t reply to any of my co-workers comments. Can you please tell me what i...

Dear all, I have currently made a pivot table, which I am linking to some Power Query data. The data in the power query comes from a folder where I import files from a website, so these files will ALWAYS have the same file name, sheet name and column names. However, the data under their...

I am trying to have the cells that are inserted be based on the keycells range. I had everything working properly but had massive delays when I tried to insert a substantial amount of columns. I then switched methods in inserting the columns which drastically speed up load times, from 45+mins to...

Dear all, (Please note that I am using the Outlook program in Windows). I currently have a setup that looks approximately like this (please ignore the snippet on the right side, it is purely to show what an email looks like in an outlook format): I was wondering if it would be possible to...

Hi everyone! I ran into some trouble trying to open the insert picture from file dialog box when double clicking a specific cell and then inserting the selected picture into the double clicked cell. I was able to get a basic code working where if you double click a cell in a range, then gives...

Hi guys I need to insert two rows after a row with some content like this: To this: I haved found this code: Sub InsertRows() Dim Rw As Long Dim Rng As Range Set Rng = Sheets(1).Range("A4") Rw = Rng.Row Do...

Good morning, I have a list of about 10 people. These folks have added files to a folder (same folder where the excel file is located for ease). I'd like to run a list where names are in ColA and next to them in ColB I would attach the files (in whatever way makes this work). I'd like to...

Can anyone help me with this code that I have problems doing for the last 2 days. What I need to do is find the last column in that particular row starting from column H onwards, if there is any text that shifts down the row in column G and repeat the action; when it finds the text in a cell it...

Hello I'm trying to figure out a code that could insert a new row where the sequential numbering mismatching. As you can see in the picture a row is missing for POS 2. I would like a code that could insert, in multiple places, during the sequence. For example, in some cases the sheet could be...

ISO VBA command to insert a dash (hyphen) as the 5th character from the left, and 6th character from the right, in a string of varying length, within an array. For example... Column Z contains the following list of values: MSEAVIMA0013S MSEAVIRM0016S MOLPVIRM0017S MOLS130012S MSEAVIRM0011S...

I have a listing of scheduled flights, and they are listed by departure dates and time. There may be days there are no flights (see image Oct 21 for example). I would like it to insert a date 21 Oct 2020 0000. Just one date, it doesn't have to match the previous or following days numbers. Once...

Hi, i made a macro by clicking the cell and inserting a picture image. But, the vba range and the sheet range doesn't match. ex. i want to insert a picture in cell b6 but it seems the picture inserts in between b5 and b6. this is my code below Private Sub Worksheet_BeforeDoubleClick(ByVal...

Hello All, I have some VBA code that I need help refining. The problem I am having is inconsistent and unexplained errors, from my research it appears that the issue is with the clipboard crashing. How the VBA code works: I have an embedded Word documents with various bookmarks and reference...

Hello, i hope you all are healthy! I want to insert the text written between two bookmarks ("Beginning_old") and ("End_old") of an baseline word document, into a new word document. In the new word document, the text should be inserted between a bookmark called "Beggining_newdoc" and a...