In a worksheet I would like to copy and paste columns with a button. It should copy two columns and insert them in the first free column that it can find. For e
I want the user's name and the date to be entered into a specified column when any change is made. I also have a snippet of code that forces any data that is pa
I'm trying to trim any combination of a webname to just web.co. Example 1.htt:pubhorn.co 2.www.pubhorn.co 3.htt://pubhorn.co 4.pubhorn.co/awawa I want to outpu
I have a raw data sheet and am trying to process nps scores from the emergency department (ANE) versus all others. I am counting the values and transferring the
How do I put default values on my dropdown? I tried view code but I'm not sure how to or what codes should I put in there. I tried DropDown7.List = Array("Link
On an Intranet web page, I have a link to an Excel document that resides on a network drive, like so: ms-excel:ofv|u|file:///N:/folder/file.xlsx This is an off
I have a simple macro that returns the date of the last save of the current document: Function LastSavedTimeStamp() As Date LastSavedTimeStamp = INT(ActiveWor
I'm trying to go through a list with two columns and replace some of the text in the second column. I want to search for values using wildcards in combination w
I am trying to find and replace the column name. I want to loop in the first row only but my code loops the entire sheet. Dim sht As Worksheet Dim fndList As V
I am trying to copy and paste data from horizontal to vertical from sheet1 to sheet3 in a lots of 200. Say I have a list of 600 tickers. The code will copy the
I have two items in ComboBox1, one is Cardio Only and second is Gym Only. I want to auto populate Renew Date in TextBox8 based on Combobox1 selection. e.g. If I
I have this awesome vba macro that takes a template xlsm file saved on a shared drive and automatically uploads the file saved as with tomorrows date in the tit
I'm reading an Excel spreadsheet using the microsoft.office.interop.excel library in C#. I need to first determine that a cell in the sheet contains a Dropdown
Lets say you have a column called "values" and "no.of times". You have thousands of rows but you don't want to scrape the data from the site.. You have to calcu
I want to create a simple line on a graph in excel that I have generated with code. I add the data to an excel sheet and can generate a single graph of that dat
I have to migrate a web automation program from IE controlled by Excel VBA to Chrome using selenium basic in Excel VBA. The website itself is not public so I ca
My code runs a model in R directly from Excel. I want to simplify installation so instead of: path = """C:\Program Files\R\R-4.1.1\bin\Rscript.exe"" C:\Users\di
I found this nice script online which does a great job comparing the differences between 2 excel sheets but there's an issue - it doesn't work if the excel file
I have an excel file that I read through org.apache.poi, but I would like to read all the values of column 1 and column 2. If the value in column
I am gluing pieces together to automate sending emails with each new line added to an Excel sheet. I want the subject line to contain the text of a cell in colu