Search results for query: *

Hi, I have cell in a worksheet ("Sheet1") that references a cell in another, Sheet1!C3=Sheet2!D4 If I drag the formula down one, I know it will reference Sheet2!D5 Is there a way to drag it down to and that it will reference Sheet2!E4? I have to do this for a lot of data and it the column in...

Hi, I have a set of significant values: 8, 8.5, 9, 9.5,etc and I want to flag when a particular value, to four decimal places, is within a 0.1 range of these sigificant values. I have a table that lists the significant value increments, in this case 0.5, and the within range value, in this...

Hi, I'm trying to create a function that will take in 10 values and will return the average of the 3 largest values. Any ideas? I'm struggling badly! Thanks,

Hi, I've used the code from the FAQ to send an email from Excel. Is it possible to set it up that it sends the email at, for example, 17:00, each day? Thanks, Vincent

Hi, I'm trying to paste a table in Excel into the body of an email, but I don't know what code is required to paste it. I've tried the FAQ but can't see anything, any help greatly appreciated! Code for copying the table and creating the email: Sub Mailer() Sheets("Summary").Select...

Hi, I'm trying to paste a table in Excel into the body of an email, but I don't know what code is required to paste it, any help greatly appreciated! Code for copying the table and creating the email: Sub Mailer() Sheets("Summary").Select ActiveSheet.Range("Orders").Select...

Hi, I have a list of values, both positive and negative ranging between -5 and +5, defined in VBA as: DailyPerf = Range("B2:B" & LastRowDailyPerf) I've calculated the Average as follows: Cells(20, 7) = Excel.WorksheetFunction.Avg(DailyPerf) I want to calculate the average of the...

Hi, I want to create a macro that if a cell = 1, that it sends an email from my Outlook to a colleague to notify them. The spreadsheet is linked to an external data-feed, so when the top row updates, and the Cell F2 = 1, it will send the email. Any ideas?

Hi, I have a spreadsheet in which I've created my own functions. There are about 6000 cells per sheet (over four sheets) that contain the four functions I wrote in VB. When I open the workbook, sometimes an entire sheet contains the #VALUE! error. Then I click into one cell, press return and...

Hi, I have a spreadsheet in which I've created my functions. There are about 6000 cells per sheet (over four sheets) that contain these four functions. When I open the workbook, sometimes an entire sheet contains the #VALUE! error. Then I click into one cell, press return and they all fill...

Hi, I'm creating a Function that looks at the max value between two cells. I can get the row number of the distant cell as I'm looking for a specific value. However, I'm struggling to get the code to return the row number of the cell that the Function is currently being run on. Any ideas...

Hi, I'm creating a For Loop to run some calculations, but I want the loop to go up in increments of 2 instead of 1, is this possible? Thanks!