run

Hi, Hope that someone can help me if this is possible to do in a formula. Sorry that I can't post screenshot of table because I couldn't get the add-in to work. :sad: Name Run Out Tim 6 1 John 5 3 Len 6 3 John 3 4 Len 4 2 Tim 2 3 How i would like to...

I have a .xls spreadsheet with macros. The macros run perfectly in Windows 10 Office Excel 16 but not in Office Excel 2019 for MAC. Do I have to convert this sheet to run the macros properly in Office Excel 2019 for MAC?

I have two date columns B and C both formatted to date xx/xx/xx I want to be able to (ideally) run a macro which searches for a specific date in column B and replaces it with a new one but only if column C is empty. As the dates that will change further down the line will be manually updated...

I am creating a user form in which there are going to be 30+ textboxes. After copy pasting a few in, deleting a few, then adding more in, the numbering of these boxes are all over the place. I am doing a routine to populate these textboxes with values from a sheet within the workbook. I am...

When i try to edit macro it says can't edit macros from a hidden workbook. The workbook in XLStart is not hidden. I've also checked to make sure it's not in the disabled add-ins list. If i click in macros and hit run the macros will run. But i can not edit them to assign a shortcut key.

Good morning, Since upgrading to Windows 10 from Windows 7, my automated reports are not working. They run via Task Scheduler that simply opens the workbooks which call the associated Macros upon opening using the Workbook_Open option. They used to open, run, copy a range of cells, send an...

Greetings Folks, I have tried to figure this out but I've yet to come across something that will allow me to make this happen. Every morning I have to open an Access File and press the "Run All" button which will do the macro that's found in the "Code" area. Is there a way that I can setup...

Is it possible to create a code in the Personal.xlsb file that runs when ever you close excel? almost like the save message on close of excel? I want to run a code that disables an addin everytime excel is closed. please help

Hi When I run the code below, I get this message But that defeat the purpose. I mean, if I entered file name as Hello.xlsm, sill I get that message. How can I improve that code? By the way, if I save the file as "*.xlsm" before running that code and then when I run the code below, I wont...

can someone help me why my userform's background image in my pc is llooking good but when i run it to my friend's pc the background image of the multipages will become small..

Hi Everyone, I have a macro below that works great but looks ugly, what i mean is it opens the pdf half way through the macro, so when you close the pdf it shows me a half loaded screen and a looks ugly before it runs the rest of the macro when everything looks great again. So I was wondering...

I have a sub that prepares a sheet to be printed. Several sheets share this sub, as they all need to have the same Print Area, etc. This sub gets called each time one of the sheets needs to be printed. I've run across a problem that only happens when I'm stepping through my code. Here's the...

Greetings! I have a question that I believe it should be fairly easy to resolve for someone with experience. I have a data set that looks something like this: <tbody> Run Order Sequence CAR 1 2 CAR 2 1 CAR 3 3 CAR 4 4 APPLE 1 2 APPLE 2 1 APPLE 3 3 APPLE 4 - SODA 1 1 SODA...

Hi Everyone, I have this macro that works great but I need it not t run if the cell I secect is zero or empty. how can I do this/ p.s. if my code can be improved feel free to go ahead and change it :-) (Columns E & F are merged per row so E88:F88 etc.) Thanks Tony Private Sub...

Hi, I have VBA routine that calls several sub routines. The subroutines link to oracle and execute .sql scripts. When I run the sub routines individually they run fine, however, when I run the call routine it stops running in the midst of a couple of the sub routines, specifically 'Call...

Hi, I have VBA routine that calls several sub routines. The subroutines link to oracle and execute .sql scripts. When I run the sub routines individually they run fine, however, when I run the call routine it stops running in the midst of a couple of the sub routines, specifically 'Call...

Hi. I have a sheet of my runs - dates, times etc. I have an average time of all my runs, however i’d like to also have an average time of my last 10 runs, to have a recent form average. Is there a way to automatically change the cells so that when a new run is entered, that is included & the...

Hi I found this macro on here that runs a macro when the delete key is pressed on book opening. What I’m trying to do if poss is to have this but to be able to have it numerous times. I.E click on delete key run macro then push delete key run another macro and so on.... Can I do this...

Hi Everyone I'm having a few problems with people wanting to copy data from word and paste into a single cell in excel as excel wont do this the way they want to so i've created a textbox for them to paste into. but what i need is for a macro called "Tide_up" to run after they have pasted is...

Hi all of you, kindly require to provide me support so that to run a VBA code which should remove the 8 left characters through col. "C". Therefore that the row 1 are the headings and the code should run from "C2". I present below an extract with original data and expected result. Thank you all...