Replies

I often change the view settings within my code. To do this I will select the range I want to be visible on screen and the set the Zoom property of ActiveWindow to True. This then adjusts the zoom % so that all of the selected range is visible on screen. This works fine for me as I mostly work in maximised windows, however, if this code is run in a Normal window it will adjust the zoom settings to suit the window size at that time, if you then maximise the window the zoom will not be at an optimum level.

I have attached a simple example of how I would use this approach to resize the view for Height, Width and Range.

Hope this helps,

I often change the view settings within my code. To do this I will select the range I want to be visible on screen and the set the Zoom property of ActiveWindow to True. This then adjusts the zoom % so that all of the selected range is visible on screen. This works fine for me as I mostly work in maximised windows, however, if this code is run in a Normal window it will adjust the zoom settings to suit the window size at that time, if you then maximise the window the zoom will not be at an optimum level.

I have attached a simple example of how I would use this approach to resize the view for Height, Width and Range.

Hope this helps,

Hans,

Many thanks for the speedy reply.

Hans,

Many thanks for the speedy reply.

Steve,

Thanks for the speedy response. I knew it was possible because I have a utility that does exactly what I want. I have been trying to fix it for a couple of hours but the closest I got was trying to find vbLf in the text string.

Once again thanks.

Roger.

Steve,

Thanks for the speedy response. I knew it was possible because I have a utility that does exactly what I want. I have been trying to fix it for a couple of hours but the closest I got was trying to find vbLf in the text string.

Once again thanks.

Roger.

Theo,

I tried using stock charts to display similar data. Whilst it was possible I didn’t find it the simplest way of getting the desired result.

Atached is a sample chart that I have prepared (with random data) using the method I decided was quickest and allowed for the best presentation of the source data. I achieve the result by:

1. Using the ‘Low’ value and a derived value for ‘Normal Spread’, which is ‘High’ – ‘Low’
2. These are displayed as a stacked column chart
3. The ‘Low’ column is given no border or area format and the series name is removed from the legend, this gives the impression that the ‘Normal Spread’ column is floating.
4. Finally the ‘Patient’ readings are displayed using a line chart.

Hope this is of use.

The attached file willl calculate any last day for any month in any year. All that is required is 3 inputs and I have included 3 different calculations that each handle the year input in a different way.

The formula that calculates the date of the last day is rather complex formula. Therefore I have also given a break down of the component formulae to help you understand how it works.

Hope this is of some use.

The attached file willl calculate any last day for any month in any year. All that is required is 3 inputs and I have included 3 different calculations that each handle the year input in a different way.

The formula that calculates the date of the last day is rather complex formula. Therefore I have also given a break down of the component formulae to help you understand how it works.

Hope this is of some use.

Thanks Steve that has done it.

Thanks Steve that has done it.

Bob thanks for your reply. The using the Add-In removes the need to replace the name throughout the workbook, which could be time consuming in large workbook.