Search results

Hi avbentes in Excel 2010 you are able to hide the worksheets by right clicking on them and selecting hide. For part of a worksheet, you can hide all columns and rows that you do not wish to be seen by highlighting the columns/rows, again right clicking the selected rows/columns and then...

Hi Narayan I have no idea why it didn't behave as I thought it would, but it doesn't. There is a lot of discussion around about this issue, so I don't believe it is something that was experienced by just me, I have been wrong many times before!!! Anyway I have gone from having absolutely no...

Hi Narayan After a bit research I have found exactly what I was after on Doug Jenkin's Blog - About Newton Excel Bach: http://newtonexcelbach.wordpress.com/2012/11/25/automating-chart-scale-limits-update/ I am not sure what it is, I don't understand how it works. All I know is that it...

Hi Narayan Yes the Max and Min values located at AH1 and AH2 respectively update as I scroll horizontally through the data. The Min and Max values are picked up when the chart is being created. To explain in greater detail, once "=INDEX([" & Stock & ".xlsx]" & Stock &...

Hi All I have managed to get a scrolling chart together utilising VBA. The Y axis (dates) scrolls as I had hoped AND I was able to retain the resolution that I was after. The problem I have now is that the X axis labels are fixed and I am unable to work out how to apply a similar treatement...

Hi Narayan I think I have applied the correct account settings, could you please re-try? Cheers Shaun

Hi Everyone I am trying to solve a issue. I have a series of charts which are prepared using VBA. currently the charts are prepared in fixed periods, 1 month and 3 months. I would like to integrate the techniques found on Andy Pope's website: http://www.andypope.info/charts/Scrolling.htm...

Thank you Hui, it works perfectly. Cheers Shaun

Hi All I am trying to limit the value entered into a cell by a user to between 0% and 100%. I am not sure of how to do this. Could anyone help? Cheers Shaun

Hi SirJB7 The file you have uploaded behaves exactly as I had tried to achieve. Thank you very much. Cheers Shaun

Hi Everyone I am preparing a user form which incorporates date, time and then selections from drop down lists. The first list is 1 to 3, at this point I would like the second list to be generated from the first, the code: Private Sub UserForm_Activate() FormDate = Format(Now(), "DD MMMM...

Hi all The relationship is between volume movements between * aac.ax - 01 Feb 2012 and 27 Feb 2012 (19 workdays); and * abc.ax - 03 Oct 2011 and 27 Oct 2011 (19 workdays). I have prepared a line graph to demonstrate the relationship. The volume movements for aac.ax between 01 Feb and 27...

Hi NARAYANK991 and juanito Dates...Sorry I have just realised that the dates I used as an example are not available in the workbook. New Workbook https://rapidshare.com/files/1378293639/Example1.xlsx What I would like to be able to do is this: Select a date range, whether I have a...

Hi all I am trying to work how to go about getting Excel to select a time period (10/05/2012 to 10/06/2012 for example) then look at the percentage movements in volume for that period for the stock selected and compare it to all periods available (from 01/01/2001 to 28/09/2012 and + or - 5%...

Hi AshbyMatt On the Page Layout ribbon there is a "Themes" section (the very left of that ribbon in my copy of Excel 2010), from there select colours. A drop down menu appears. At the very bootom of that you should see "Create New Theme Colours...". You can define new colours here and save...

Yes, I left out most of the recorded macro. I did edit my post shortly after, which must have been missed. My apologies. Cheers Shaun

Hi AZExcel Your code would be changed to: Sub Confirm() Dim UserChoice As Variant UserChoice = MsgBox("Are you sure you want to do that?", vbYesNo, "CONFIRM") If UserChoice = vbYes Then Range("B4:C4").Select Selection.ClearContents ActiveWindow.SmallScroll Down:=9...

Hi Narayan Thank you, it works perfectly. Now I have to learn about INDIRECT(). I have read previously that the & works in the same manner as CONCATENATE(). I don't know if you too a look, but are you able to explain why my attempts kept failing, what was causing it not to work? Cheers...

Hi all I had an interesting issue crop up today to which I am trying to resolve. I have a list of wage payments made to employees net of PAYGW (Tax Withheld). I need to reconcile this back to gross wages. I have compiled two additional worksheets which contain Tax tables and some...

Hi All I am trying (without success) to convert a list of dates (21/07/2012 format) but when I select a cell containing the a date and change to format to text I get 41111. When I place a ' in front I obtain the correct result, text in the format of 21/07/2012. I need a VBA solution where...

Okay I have the software up and running...had a bit of play...seems doable!! Give me a week and I will share what I come up with (time permitting of course) Cheers Shaun

Hi Narayan I could not get your solution to work :( I will need to invest some time to go through the link provided by sirJB7 and try and get my head around it. The problem as I can see it is that the "Help" button is treated differently to the others, where OK, Cancel, Abort, Retry, Ignore...

Hi Guys SirJB7 that is a great link, but requires other applications to make work (which I don't think I have) or rights to install. I might but trying to take a short cut which isn't really there, but, I have changes the message box code to: CHTStep22075YN = MsgBox("Does the " &...

A help button... Is it difficult to prepare the help file and button? Google is my friend, I will have a look around to see what I can find. Thank you both for your help. Cheers Shaun

Hi Ajinkya, A possible soultion could be: =IF(A1>100,"",IF(A1>90,"D",IF(A1>80,"C",IF(A1>70,"B",IF(A1="","","A"))))) I am sure those more skilled in Excel will have a much more elegant way to solve your issue, but this works. I am not sure, but you may need to tweak the...