yesterday

Evening All Wondering if someone could lead me to an alternative. The below Loop deletes the row if a cell condition (Text "Test") is located in Column J, also looking to delete the 3 rows above. Coincidentally found a similar request on the forum yesterday, however unsure how to amend. Thank...

I created a thread yesterday https://www.mrexcel.com/forum/excel-questions/1102769-how-set-range-vba-active-cell.html and this is the continue of my macro which I believe has to change what I had help with yesterday . Sorry for not thinking the whole thing through before posting Here is what I...

Getting a really frustrating crash, which is happening -every- time a macro opens another workbook. The workbook hasn't changed in name, type or anything since yesterday when it was working. It was working yesterday, Tuesday, Monday, all last week and every day before that. Today, it crashes...

Dim RowNumber as long RowNumber= Columns("B").find(what:=cboJump,,xlValues,, xlRows,,,False).Row The code is in Worksheet cboJump_KeyDown event. I'm sure this worked yesterday I also tried Dim Rownumber as Range and "Set RowNumber = ..." but same error.

Yesterday, everything worked fine. Today, now I get the same error on every control I select. I also tried a completely separate workbook (nothing in common with the first except both use VBA) and got the same error! :confused: The only change I made yesterday to bothwork books was adding in...

Hi to all. I got a problem with my excel sheet, since today I haven't been able to open my excel document. Cause of I don't know the reason what happened yesterday. I was working some hours yesterday evening, and the file was valid. Today at opening, I see only blank screen in MS Excel. I'm...

Hi all, My sheet gets production numbers via a getpivotdata formula. That part works fine. My problem is that the original Pivot is only valid for today and I need to track numbers for a whole year. So I use getpivotdata to show me what we did today, but this only shows me what we did today...

I am looking to copy and paste as values (due to formulas) all rows whose column A has a date equal to today or yesterday. This report is run at the end of each day and needs to have certain information from the past two days. Both sheets have the same columns and format. The paste should...

Installed an xla file; didn't like and removed it. Tried to remove complaint via Options; didn't help, but could open Excel. Yesterday, after Win 10 update get error PLUS Excel will not open.

Alright, I am making a to do list that is pretty automated that will add sheets and delete sheets as the days move forward (Dates in the past will be saved to a folder and deleted, current/future dates will remain). This is the bit of code i'm having a lot of trouble with. The main...

I have a workbook with several spreadsheets that have a column that we track a physical inventory in a fuel tank. I am trying to come up with a formula that will point to the correct column (Column L), use the number from yesterday and subtract the number from the 'day before yesterday'. I...

Hi All, I have a worksheet for which I want to automatically input data in daily. I am stuck on how to write a macro which selects the next blank cell in row 1 and inputs yesterdays date (DD/MM/YYYY)? Secondly, I then want to be able to run a calculation (e.g...

Morning all, Firstly, the version I'm using is Excel 2007. I wrote a macro to filter my spreadsheets then copy and paste the relevant data into a new spreadsheet. The criteria used are: find all data created on the previous business day & find data that was either "new" or "updated" on that...