Im currently using this. while this works for now. Im looking to add code that allows me replace everything in that column. Not just limited to only replacing t
I have earth flow displacements in two directions, converted to point data, which I am trying to combine for an overall offset direction (point to where the flo
I have tried searching on SO, and certainly have not found solution for similar problems, may be I haven't used the right word to search. So, Column A & Col
I am trying to convert a field in an excel sheet (e.g. REC_LEN) to camel case. I am using this formula to do that =LEFT(A1) & RIGHT(SUBSTITUTE(PROPER(A1),
I'm still reasonably new to VBA and I'm trying my best to learn, but this one has stumped me. I have a Userform where one of the textboxes is for a user to ente
I want to find mail in the olFolderSentMail folder, using the domains of the email addresses, with VBA. When I make an advanced filter in Outlook, the result co
What I am trying to achieve is as follows, I have "Workbook A" and "Workbook B", within Workbook B there is a worksheet "SheetB2" which I would like to be inclu
I'm attempting to calculate periods of out of stock for a fleet of rental equipment that has been in service for the past few years. I'm having trouble creating
I have 2 columns I am trying to populate in my sheet using vlookup. One column is the buy amount and one is the sell amount. I am using 1 unique ID to lookup in
I can't figure out how to prompt the user for a folder path and the save name. Below is the code I have gotten to work. Sub PrintToPDF ThisWorkbook.Sheets("Sh
I am using the ClosedXML package (version 0.95.4) to open an Excel file (.xlsx), which was previously saved in a folder to which the application has access. Th
I need to export HTML table with data from database to xlsx file as easily as possible. I've tried PHPExcel and some JS plugins, but unsuccessfully. Is there
I made a PQ append query, send reults to Data Model and then uploaded the pivot table to the excel sheet. Now I'm trying to apply filter based on the cell value
I am getting a Runtime error 1004 and when I debug it, it takes me to this sub, this sub works fine in another sheet, I don't know whats wrong, can anyone help?
I'm trying to parse a json file but the file is set up in a strange way that excel is having problems deciphering. Please see code example below. "in_network":
I'm trying to add a toolbar control on a sheet. I get this error. It does add the toolbar, but that error is not skippable with On Error Resume Next, so it stop
I am using this code: Function wrksht() as Variant wrksht = Application.Caller.Parent.Name End function I am continuously being thrown run time error '424' ob
I a process have a Start date of 1/1/2022 and end date of 3/15/2022, date is in it's own field. Now I have a field for every Month in the Year: J F M A M etc.
I know that this is a really long post but I'm not sure of what part of my process is making my file crash, so I tried to detail everything about what I did to
How to write a list of list into excel using python 3? new_list = [["first", "second"], ["third", "fourth"]] with open("file_name.csv", 'w') as f: fc = csv