Search results

Excellent, thank you. I am a novice at vba but thanks to this forum I am learning.

Many thanks to all. It is now fixed just by commenting out these lines of code ' With UserForm1 ' .Top = Application.Top + 320 '< change to what you want ' .Left = Application.Left + 850 '< change to what you want ' End With

Apologies for the wrong forum and thank you for your response. I get no error messages, the userform just does not appear. The userform has a command button on it which when clicked opens outlook and copies a range from the active worksheet as an image to the body of the email plus it also...

Sorry, I forgot to attach the file

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...

Thank you Marc. I was really struggling with this, I think I was trying to make it more complicated than it actually was.

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...

Absolutely brilliant, thank you all so much. It looks easy when you know how.

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...

Thank you for the responses. I think I solved it by adding a UserForm with a button and its code to the workbook and setting the form property "ShowModal" to False.

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...

Brilliant, thank you. Now why couldn't I do 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...

A big thank you to all of you. As an Excel novice this might take me a little while to digest.

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...

Thank you for your help.:DD

Hi pecoflyer Nothing at all, I just tried it and it worked brilliantly. Sorry if I offended you, but using AGGREGATE which I have never used before was a steep learning curve and I still haven't got it straight in my own mind what it does.

Thank you all for all your help, I am nearly there!!! In the spreadsheet I have used this formula in Col L =IFERROR(INDEX(A:A,MATCH(K3,C:C,0)),IFERROR(INDEX(A:A,MATCH(K3,D:D,0)),IFERROR(INDEX(A:A,MATCH(K3,E:E,0)),IFERROR(INDEX(A:A,MATCH(K3,F:F,0)),INDEX(A:A,MATCH(K3,G:G,0)))))) However it will...

Thank you, I'll give it a go

Hi, ooops - sorry. spreadsheet attached. What I was trying to do is in Column L I would like the date from column A that the number from Columns C:G last appeared ie the most recent date on which the number was drawn. For instance the number 1 should show as 29/01/2021 in Col I. Many thanks

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...

A quick thank you for all suggestions and apologies for not reposting sooner (Mauritius seems to have intermittent connection problems). I finally worked out with your help that using ranges across multiple worksheets, or trying to use a range across multiple worksheets doesn't seem to work so I...

I'm really sorry about this. I have tried to simplify things and rather than have vba do things in 1 sub I have split it into 2 with 2 command buttons. The first part seems to work fine and produces a range of the right cells. The scond part doesn't work, I get a "next without for error". Any...

Hi Marc, The error occurs on the line "Set allRngs = Union(CampusCurr, BusCurr, EduCurr)". As a real novice I don't think it is a typo so probably syntax. I've tried putting the range names in quotes and a lot of other things with no luck. Thanks for the help

Moving on but not very far :confused:. I tried writing the code below (actually the first part which works fine was written by someone else, the second bit was written by me and doesn't work at all) Private Sub CommandButton1_Click() Dim sh As Worksheet, cel As Range, rng As Range For Each sh...