sheet # change

Hi all, I want to know if its possible the below scenario: I have a table, with some formulas here and there, but in column O, I have a formula with some conditions and dependent on other 3 columns in same table. What I want to know, is, if I can have some kind of script that every time...

I want to call a macro when a cell in the range H2:FAX changes (for all sheets), where X is the last row. However I can't get the event macro posted in ThisWorkbook to call the macro consistently. I did get it to work a couple times by chance, and it worked fine for a while and then suddenly...

Script below: Dim rng As Range Set rng = Range("BJ5:BJ500") Sheets("Daily Runboard").Activate For Each cell In rng If cell.Value = "MCC" Then cell.Select ActiveCell.Offset(0, -59).Select ActiveCell.Resize(11, 22).Copy Sheets("H Runs").Select...

I have a very strange problem. I have a workbook with sheets 1 - 18. But there is no Sheet11 showing in Project Explorer. If I debug.print looping through all the sheets none of the code names come back wit Sheet11. However, I have msgbox that runs on Workbook>Open that is not happening at the...

Hi all, I would like to have an excel file where I can easily navigate through the sheets. I have sheets for each week, but when I need an extra week, I would like to add a next sheet with one click. A macro is required for that. When that macro adds a new sheet, I would like the macro to...

Hi all, I'm trying to set up "protection" on my sheets, and so far sheet.protect doesn't do the job, because I have tables and I don't want my users to be able to add columns to the tables but AllowInsertingColumns = False still allows table columns to be added. So I think I have a solution...

Hi All I have a problem with my code. I need to call on a .csv file, format it, select a specific dynamic range and paste it in the sheet the macro was called from. I managed most of the above, however, i can't get it back to the sheet the macro was called from. I have tried multiple options...

Hi guys, I have a formula looking like this: =VLOOKUP("Name",'C:\Users\mass\Desktop\stats[SCORECARD.xlsx]Sheet14'!$D$30:$K$30,5,FALSE) This allow me to find the value adjacent to the cell containing Name in another workbook. Now... I want to be able to write something like SheetA1' instead of...

How do I code a macro to run "If" a new sheet is added? My code works with a button, I am trying to make it automated when a sheet is added or deleted. I appreciate any help on this topic. Thanks in advance.