excel

I simply need to change the font of a row after the table last row + 2rows for cells from ("A: M") but I don't know how to write that in VBA code ... I have a code to Addnewrow and I wrote the last section in the below code but unfortunately wrong any sugesstion please Sub Addnewrow() Dim...

https://stackoverflow.com/questions/79338433/the-vba-code-slows-down-the-worksheet-needs-to-be-faster?noredirect=1#comment139908100_79338433

In my line of work, virtually every company uses some combination and variation of VBA tools that essentially links Excel & Word documents to produce ±100 page report deliverables. Most of this is done through VBA tools either made by 3rd party technology solution providers, and some are...

Hey Everyone, I am in Word VBA trying to populate a table that sources from an Excel file. The Excel file has hardcoded numbers and no formulas at all. There are several worksheets and currently, there is only one Named Ranged, which is StartRow. StartRow is workbook scoped and highlights the...

I am trying to make 2 separate Employee Schedules, One has a list of every employees name and the shift location and time for each day of the week. The other is a daily schedule that shows which shift they are working and time for that specific day. For each day I used the formula...

I have a code to copy data bewteen two different workbooks while the source file is closed and it's working perfectly but with one problem which is when the source file is closed with active filters in the table i get a problem in the data copied to the destination file So, what I need is to...

Hello, I need help writing a macro for a spreadsheet. I would like the macro to time out a spreadsheet after ten minutes of activity. I would also like a pop up window to ask they user if they are still working, and if they do not respond to the pop up to automatically save and close the...

In excel by pressing Ctrl-O, I can see the open dialog with two tabs "recent" and "pinned". if I right click on any item in them, I can see "open" and "open a copy", but no open readonly. To open read-only I have to click browse and navigate to the right folder, locate the file and there is the...

Dear All, I need your help! I have column A in which I have months and column B which has status, it will have "Y" or will be blank. I want a formula in D6, where based on "Y" in column B, it combines the month name. 1) If the range is consecutive then the formula should give result as the...

I would like to try some VBA code that remembers where the cursor was (row number) but go to the required column, and I have no idea where to even start. I currently have a hyperlink that allows me to go to the today's date column, but always goes to the top of the page, instead of the row the...

Is it possible to make a macro automatically execute (run macro) every time a new email arrives? Can something like: Private Sub Application_Startup / Triggered() be added to the code? Or at least add a macro command to click the blue button = (run macro) every time a new email arrives or to...

Hello! I'm trying to get a VBA code to work where Excel detects if a date value is present in column M in Sheet1 and, if so, copies the entire row to the next blank row in Sheet2. Then Excel should delete that row from Sheet 1. Column M will be dates in short format (mm/dd/yyyy). I need the...

Hello, just very interested how to do it , tried everything i knew. Got the next lesson: Set the name of cell B15 to 'criterion1' and the name of cell B18 to 'new'. Assign a validation (input check) to the cell named 'criterion1', which allows you to select one birth month from the list. Write...

Hello everyone, In Excel, I entered two numbers in a single cell by using the Alt+Enter command to add a line break. I want to calculate the sum of these numbers, but I don't want to use VBA. I know ChatGPT can write VBA code, but I am looking for a non-VBA solution. Could someone help me with...

Hi All. I have an MS Office 365 Excel workbook which analyses data and provides charts to show results and "filterable" data. I have buttons for navigation from a dashboard. When I navigate to any sheet for the first time it has parts of the sheet greyed out. If I navigate to another sheet...

Hi Tech, Need help with VBA-generated QR Code based on values in certain cells......................... Series, Firstname, Lastname, Math Grade, Stat Grade, English Grade, Email, Tel, Notification. Thank you

I'm having an issue with a FILTER function that is just sending back a value of #N/A and the error help obviously doesn't say too much. Hoping someone here can help. My formula is =FILTER(TimetrackedLogs!$A$2:$N$200000,TimetrackedLogs!$N$2:$N$200000="my_value","No results") Column N in the...

Can somebody help me fill in the green column. Please also put what is missing the the formula and show me where to put the correct functions in row 1 too. I was using Clearbit V1 API. initially. GET https://autocomplete./companies/suggest?query= name...

I have a macro which works the way i want it to except for this part.. Set rng = ws.UsedRange.Columns(1) .Cells(r, "H") = rng.SpecialCells(xlCellTypeVisible).Count it returns y, instead of x in (x of y records found) this happens after autofiltering with vba.

Hi there I am looking for help on writing some VBA code for the following. I have an entire data tab (titled "paste 1804") I need copied into 2 different tabs with same format, content, etc..: I have Macro push button labeled "Run data Macro", on a tab labeled "Marcos" Source tab to copy...