Search results

Hi, yes, the later, I want to know how the prompt can be cancelled with a default NO in VBA. Using Application.DisplayAlerts = False, doesnt work (it defaults it to YES, as far as I can tell)... I havent been able to find any documentation about this anywhere....

Thanks, I can confirm I have not exceed the row/column limitations, nor am I using any formulas that arent supported in 2003. My question is how do I control this alert in vba? It is this prompt that comes up when saving a .xlsx to .xls: "Defined names of formulas in this workbook may...

Hi all, I have been working on a dashboard that is continually being added to and refined. This report needs to be saved in a .xls format to ensure everybody in our company can open it without any problems. I have written some code to save it in a number of different formats, and that was...

oh so simple...and thats why you're a ninja...! thanks heaps, I was racking my brain so hard trying to get it to work, and I was stumped as I had used getsaveas many times before!

Hi Hui, essentially what I'm trying to do is specify the filename, but allow the user to choose the file location, which is why I have created the sCampaignName variable.

Hi, I'm having a problem with the following code - the getsave as method works fine, but it comes up with a runtime error, on the saveas line. I think its something to do with the Initialfilename string, but havent been able to figure it out. Dim sFileName As String Dim sCampaignName As...

thanks, I'll give that a go. I've got a bit of code in the worksheet to drive interactive tables/charts, so I'm not sure if that will still work in a .xlsb? All of my data is just numerical, only text is in the column headers.

Hi, I've got a workbook with about 6 worksheets, and it is about 3.5MB in size. I'm trying to reduce its size, as it is something that will be emailed out regularly. I've done a bit of research online, and have tried all of the usual tricks (all formulas pasted as values, go to last...

Hey Hui, it is possible (in my dataset) for somebody to have an A grade, but a zero score...! I know it doesnt make sense when you first think about it, but it does make sense if I were to explain it fully (that would take too long to do). Im actually working with sales data, but to keep it...

my above post came out a bit funny, in column A you have all of the names in column B you have all of the grades in column C you have all of the scores

Hi all, I have a question on array formulas. I have come up with a formula that achieves the desired outcome, but I wondered if there was a more elegant solution. Essentially I want to calculate a conditional percentile. My data is structured as follows: A B C Name Grade Score John A 45.67...

Hi, are you using 2007? Probably easiest way would be to hide the formula bar, by going to excel options => advanced =>display =>unselect the option display the formula bar.

Hi ahhhmed, sounds like all you need to use in column D is the averageif formula. This works in a very similar to the countif, sumif formulas, e.g. try =AVERAGEIF(A1:C1, ">0", A1:C1). This will only take into account the values that are greater than zero...does this resolve your problem? Prem