edit

Hello, I'm trying to copy two worksheets from one workbook to another. This seems to be fairly straight forward, but for some reason, I can't seem to accomplish this with a variable sheet name. I have set one of the workbooks to "Report" and the other "Edit" The "Edit" workbook is currently...

Hi Guys, I am trying to run a piece of code in all the sheets in a workbook. However my code is only editing first sheet and then courses through other sheets but does not edit them. PFB the code: Sub Worksheet_Editor() For Each Worksheet In ThisWorkbook.Sheets Cells.Select...

MP3 files have imbedded metadata that I would like to edit. I have between 35K and 40K files that I would like to edit one or two fields in each. I would also like to export to an Excel database a selection of fields: Title, Artist, Comment and so on. I can open each individual file in File...

I have a comment box that displays in a very bad position on my Excel 2016 Spreadsheet. Even when I move it under the Edit Comment Function, when I hover over the cell, it still displays in the the comment box in the original position. Is there anyway I can lock the comment box in the location...

Hello friends, Hope all is well! Need your help please. I want edit the code below. it supposed to show only excel cells, no ribbons whatsoever. I know there is the manual option of 'auto-hide' ribbon; but I am wondering if it can be done via VBA. Can you pleas help me edit the below codes...

Hi all, I can't seem to figure this one out by searching. It seems to be such a simple thing! I have a text box that fills a listbox with team names. After the user fills in a bunch of team names, I would like them to be able to click on one of the names in the listbox and edit it. I've tried...

Hi there. I want to edit the connections of the activeworkbook doing something like: Dim oCon For Each oCon In ActiveWorkbook.Connections oCon.Refresh BackgroundQuery:=False Next oCon The code above does not works. How can I do that? Thanks! EDIT: Better explain: I want to disable the...

Hello friends, hope all is well! Really appreciate your support please I have a range K9:K150 I placed the following formula: =IF(AND(COUNTA(A10:E10)>0,C10=""),"FALSE",IF(C10="","",IF(ISERROR(VLOOKUP(C10,Database!$A$2:$A$24,1,FALSE)=FALSE),FALSE,TRUE))) Now I wish to count the number of...

I am trying to lock/protect certain cells so that they can't accidentally be deleted or changed, yet still be able to edit the other cells. I don't want to use a password to unlock the sheet everyday, just if I need to adjust those protected cells. For example, I want B3:B34 to be locked but I...

Dear All, good morning, I have a spreadsheet and I have added comments. I have - up to now - been able to edit the comments without problem. Today, I have tried to edit the comments but it won't allow me. When I right click / edit comments, the comments box won't open. Could someone advise...

I use this code to erase highlighted cells after a search. Is there a way to edit this that would put the original cell color back in,maybe looking at near by cell. Thanks Sub Remove_Color() Application.FindFormat.Interior.Color = vbYellow Application.ReplaceFormat.Interior.ColorIndex =...

I have a macro that scans a list of orders to find those belonging to a certain customer. When it finds one it displays the order and then finds the next one. What I need to macro to do is let me edit that order (i.e. edit what's on the screen) before carrying on to find the next one. Is...

Hello Excel Masters, I need help in regards to my work. I am trying to create a EDIT Querry to be connected to MS Access but it seems my code won't push thru. The Save and Delete button of my work is already done. I just need the EDIT button to work. Here is my code. (it will be getting a...

Hi All, I have created the userform using VBA too add the data and i am able to add the data as per the requirement, However even after spending two days i am not able to apply the formula to edit the data. can anyone please help to resolve this. i am sharing the codes which i have used to add...

Hi All, I have a sheet with approximately 75K rows. My code is adding columns, formulas and formatting working great. I would like to stop the code in the middle/at specific points with a message box to allow me to do a manual edit on the sheet. For instance, have a message box pop up with...

So i have a question about "allow edit ranges". I Just learned how to use it but i wanted to know if there is a way to paste information in the cell. To be more clear, I have a B:B under the allow edit ranges as well as L:L. But I have others copied information and pasting in the same workbook...

Dear all, I have updated excel version to 2016. My master data file is linked to many supporting files from different locations (last year & different months). In previous version, Edit links was showing file names (and it was very easy to identify which file is required to update). In new...

PROBLEM: I have 2 forms in my workbook. An entry form, and a edit form. The problem I have is with the edit form. For reasons too long to get into here, I have no blank cells within the spreadsheets range where all the data that is entered and is stored. When a cell is left blank (when...

Hi folks. I have inherited a complex set of 200+ workbooks which all have references to a master workbook embedded in the VBA. This reference is coded as a constant as follows: Public Const ValidName As String = "masterbookname.xls" Is there any way I can edit the VBA code without opening...

Is there any way to be able to access a spreadsheet based distribution list from outlook without having to create and then edit (as changes are made in the original spreadsheet) a static contact list in outlook?