running

Good morning all, This is my first post here and I am far from being an Excel guru so please excuse my ignorance. With that said, the problem I'm having is: I have a 2 sheet workbook, SHEET1 is daily sales and SHEET2 is year to date (YTD). Sheet 1 carries over to sheet 2. At the end of every...

Hii, I'm getting error code 91 object not set while running this sub. while when I debug and go lie by line by pressing F8 it doesnt show any error and run smooth.Please help. i would be really thankful. Sub systemLogin() Dim objIE As Object Dim uName As String Dim pAss As Variant uName...

The code below is being used in other VBA functions, but will not work in this setup. I get an error when running the code. The error is "Sub or Function Not Defined". Rows("1:17").EntireRow.Hidden = False Anyone have any ideas? **FIXED IT MYSELF** I was an idiot and forgot the (s) after...

I have a very strange issue that I'm hoping someone can help me with. I've written a macro to automate a weekly task my wife has to perform at work. It involves sifting through a long list of raw data records and copying them to other worksheets in the same workbook according to specified...

Hi, I'm not sure if if this can be done, but i figured I'd ask. I have code that opens another workbook and changes data, which generates a userform that you must then click OK for the code to continue running. Is there a way to "bypass" that userform, by writing code that will click the "OK"...

When my Append quesry is ran the user gets the Pop questions (You are about to run.....) is there a way to stop this and just append the data. It confuses my users and out of precuation, they dont want to click anything and they come running to ask what to do. I want it to just go ahead and...

If I have a workbook that has 365 sheets that each reference a date and are labeled in a MM/DD format; is it possible to reference those sheets depending on the current date which is subsequently their name? For example, this formula takes a running total from a previous sheet titled "Sept 16"...

First off, I'm an Excel novice! I'm rebuilding a spreadsheet to track training that was built by a previous employee who is no longer here. And now I need to add a sheet to track hours, and I'm utterly confused on how to do it. I can't post a picture, so hopefully I can adequately explain...

Im trying to find out why this is not working, and google is not having a good day. i have a simple vba code, without any complications, and i"m just wondering what I'm missing. Im in cell "O2" and i just cannot get this up and running......if anyone knows why i would really appreciate it...

In a table with structured reference: One column with rows containing multiple text values. In another column, a running total by row of the number of occurrences in the column one of those text values. WorL, Running Total Wins W, 1 W, 2 L, 2 L, 2 W...

Hi I would like to use a pop prompt to disable a particular sub within a module from running? The prompt would appear on opening of the workbook. If the user clicks "No" this would disable the sub from running. Is this possible to achieve? Many thanks

Hi, Is it possible to use running range in access formula like we do in excel Example: row 2, max(a$2:a2) row 3, max(a$2:a3) row 4, max(a$2:a4) and so on...

Hello! If anyone can help me out with suggestions, I would appreciate it. The coding I have below will run fine if I step through it, but if I run the macro it runs part way and crashes excel. It's been modified several times, but what I'm trying to do is copy specific excel tabs and save them...

Hi, I'm refreshing a colleagues sql based table, that is then use by a variety of calculations in the same spreadsheet. It seems like its running okay but then the progress bar at the bottom right changes to state 'Rows:' and hardly moves. I left it for an hour and was only around 30% filled...

Hi All, Imagine days, months and years running along the top 3 rows. All cells are small squares that can only fit 2 digits in. Running along row 3 are the days of the month, i.e. date cells (21/08/18) formatted as d Running along the row 2 are the names of the month on the 1st of each month...

Hi We're upgrading to XL2016 at work in the nearish future. We haven't many macros here and none are mission critical, but are there any changes it's worth knowing about before the upgrade? I'm not worried about new features at this stage, e.g. new properties, but I need to know if anything is...

I have some code that automates Internet Explorer. I have IE.Visible set to True so that the user can make sure all data is being entered correctly. The problem I'm running into is that if the user closes the IE before the sub is done running then at the end where I have IE.Quit, it breaks and...

Hello I can't get Excel and the Pivot I have made, to use the running total (the accumulated sum) when I am trying to use it in a calculated field. Does anyone know a way to make a calculated field, that uses the running total in calculating something else in a pivot? Or is there another way to...

I know the Running ants show up when Copying and Past….. But is it Possible to get them to show with out doing the Cop/past function when a value is set en a Cell Hjemmet

Hi everyone, I'm running the Solver add in, trying to find combinations of cells that sum up to a certain value. It's been running for over 20 minutes, maybe even longer. Right now it's on "Subproblem 4700" or so. And the "Trial Solutions" are going by very quickly. Does anybody know what...