Recent content by Gandalf

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