Search results

I have an embedded Outlook email message in an Excel spreadsheet. There are email recipient addresses in for e.g. Cell C5. What I want to do is have a macro on a button that when clicked, it will open the mail message and insert the recipient addresses in the 'To' list. I just need help on the...

Thanks for your responses, however I've had to go a different way. I have an embedded email template in an Excel spreadsheet. I have a list of email recipient addresses also in the spreadsheet. Using a Macro, I am able to open the embedded email message, however then I am having problem...

Could someone assist please? I need to send out emails to several addresses. I have these addresses in an Excel spreadheet and select the relevant addresses I need which are then stored in a couple of cells, e.g A1 & A2. What I need to do is to then create an email message with the addresses...

Hi team, I have two cells, A1 and B1. If cell A1 value is "TRUE", I want to disable/lock cell B1, so that it cannot be changed at all. Is there a formula that can perform this? I am trying to avoid macros, but if necessary I will have to use them.

Hi ahhhmed. What do you mean by changing the name of original file. I will still eventually have the same problem, won't I?

I am having an issue which may be more related to Internet Explorer than Excel. I have a spreadsheet which I have made available to a wider audience by making it available from a web page. However, when I use IE8 to access the link, it brings up the Excel file with [1] at the end of the file...

Guys, please ignore this thread. The issue is actually being caused by an error on my behalf. Thanks.

Can someone help me with this? I have created an Excel spreadsheet that I am giving a wider audience access from a website. The spreadsheet contains a link to another external source. When I click on the web link, I receive the window and message about updating links. There are two links and...

Sorry, my poor explanation. I suppose I mean the results are what I want to delete, and keep the formula. I hope that makes it clearer.

Hi Guys, How can I delete the contents of cells, but not the formulas that I have in these cells. So, if I had contents/formulas in cells A5 to D15, can I put these into a macro that would only delete the contents, but retain the formulas. Thanks.

The ScreenUpdating worked fine. Thanks to all who have help me with this, much appreciated.

Hi, Thanks for the tip. I used the DoEvents as suggested, but it still did not work. However, I then combined this with a Wait, and it works how I wanted it to. (I have also tried the Wait by itself and it did not work) Sub Rectangle1_Click() ActiveSheet.Shapes("Rectangle 1").Select...

I removed the calculate and I do see the colour change. But in the original format why does the change happen after the calculate? I can't see why that happens.

My calculate is not fast, it takes about 15-20sec to perform this, however the colour change still occurs after the calculate, even with the macro simplified as follows: Sub ColorChange() Dim OriginalColor As Integer ActiveSheet.Shapes("Rectangle 1").Select Selection.Interior.ColorIndex =...

Thanks for the response and information, however I am having a problem. Using the macro below, the colour change does not happen, but the Calculate does. What am I doing wrong? Sub ColorChange() Dim OriginalColor As Integer 'You need to make a note of what the name 'of your shape/button...

I am using Excel 2007 and have a spreadsheet that I have a button that when clicked runs a macro that just performs a manual calculation of the workbook. I want to change the colour of the button when it is clicked, and then return it to original colour when the calculations have finished. From...

Thanks guys. The formula worked perfectly; it was operator error which caused it to fail initially.

I am using the following formula: =IFERROR(INDEX($A$16:$A$21,SMALL(IF($A$16:$A$21<>"",ROW($A$16:$A$21)-ROW($A$16)+1,ROW($A$21)),ROW(A1))),"") Which removes blank lines, but it is only when there is one blank in between rows. How can I alter this formula, to account for varying number...

When using the in-built Conditional Formatting tool, is it possible to actually alter text in the selected cell or can you only do the things such as font change, fill/border colour etc. For example, if I had the word "OLD" in Cell A1, can I use CF in A1 to change it's contents to "OLD ANIMAL"...

Thanks Nararank991, and you were right bobhc, it works perfectly. I wouldn't have been able to figure it out for myself. I'd already beaten my head against a wall.

Thanks Narayan, I'll give it a go.

If I have a column i.e. ColA Apples Bananas blank cell Oranges blank cell lemon What formula can I use to get output in ColB, i.e. a continuous list of values from Cola without the blank cells in between.) ColB Apples Bananas Oranges lemon