Search results

Hi, me again I have a bit of code that opens a userform when the workbook opens. This works fine on the PC that it was written on but when I open it on my laptop (Panasonic Toughbook cf-19) it fails to open. Both machines are running the latest Office 365, Windows 11 pro and it is a trusted...

Me again - sorry! I've attached a worksheet where I want to delete a whole row when only a part of the row is empty. The number of rows is variable and cols A & B always have data (dates). Cells in Cols D to N may or may not have data. I would like to be able to delete the whole row where all...

Hi, I am able to add worksheet ranges and Sheet names to an Outlook email body. Is there any way of inserting a range of addresses from a worksheet into the recipient (.To) field? The addresses are in another Worksheet (not the ActiveSheet) called "Volunteers" range D2:D40 Private Sub...

Hi all, thank you in advance for any help. In the spreadsheet attached on the Schedule worksheet the button for copying the schedule sheet (the top button) copies the worksheet to a new worksheet. Is there any way I can include the "copy for email" button and its associated macro in this so that...

Hi On the attached workbook I would like to add a line to the Cost chart (Charts sheet) which corresponds to a cell value (cell J2) in the Readings sheet. I have tried numerous ways from recommendations on-line but cant get any to work. This is probably very easy but like a lot of simple things...

Hi Could anyone help me. I am trying to write a formula to count how many times a particular number occurs any particular month. I have tried using both the countifs and aggregate formulas and either Excel stops me entering the formula or gives an error message. I've attached a part of the...

Hi All, I wonder if anyone can help. I have a spreadsheet for lottery numbers, ColA is the date, cols B:F are the results. Col I is the numbers 1 to 50. For each number in col I would like to look up when it last appeared in any cols B:F and enter the corresponding date into a cell in col J. I...

Dear All, it has been quite some time since I last posted here so it is good to be back. I have been preparing a workbook for my wife which looks at all staff and department costs and incomes to see which are profitable and which are not. As we are currently based in Mauritius for a UK based...

Dear All I am close to tearing my hair out on this one :mad:. I have an excel file with some, but not too much VBA which works fine until I save it to another drive, the copy gives me the error message so I go back to the original and that gives me the error message as well. On both copies the...

Hello everyone, I hope you are all well. I am sure someone will be able to help with this. I have a textbox on and excel sheet that I want to position according to whether the active cell is within one of 3 ranges or do nothing if the active cell is outside of these ranges. The code below does...

Hello All, I hope that this isn't a repeat question, I have searched through the form. Is there any way I can have a MODEIF formula (a bit like sumif etc). Many thanks Gandalf

Hello All I hope someone may be able to help me. I can generate 2 lists of unique data from 2 columns that I then use in list boxes on another sheet using the code below Private Sub Worksheet_SelectionChange(ByVal Target As Range) ActiveSheet.Range("C2:C311").AdvancedFilter...

Hi All Can anyone help me? I have an number of excel line charts which dynamically change when I add new data every month. This data also has a trend line which I would like to always forecast forward a fixed number of months i.e. it would always forecast to 18 months from the first data point...