Calibrating a horizontal scroll bar formula
HI all and Happy Memorial Day!
I originally posted this in VBA as I though it was a code thing, now that I have had time to consider it, it may be a formula issue/resolution?
I have a sample attached, and in X9 I have the formula =F3+AF4-(F3-D10) which F3 is the Start Date of Project, AF4 is the position of the scroll bar and F3-D10 is the calculation of the start date and lowest date in schedule. This formula starts my calendar date at the formula calculation, =F3+AF4-(F3-D10) and row 10 is the last row in the Freeze Pane.
So, what I am wondering is there a way to reference the next row after the "Freeze Pane" or row 12 in this sample keeping in mind it will move when scrolled. So, if I scroll to row 30 (In this sample) and row 30 is directly under row 10 "the Freeze Line" then my formula would change to =F3+AF4-(F3-D30) which would move my bar chart to that day in X9 so it will follow the dates in D when scrolling down or up. What ever date in "D" directly below Row 10 is, that would be the formula.
Any ideas on this. I am not sure if I can reference this in this way.
Thanks to all,
Re: Calibrating a horizontal scroll bar formula
Please close this post as I think I need to post in a different forum.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By davidpierce in forum Excel Programming / VBA / Macros
Last Post: 05-25-2015, 09:06 AM
By jmoffat in forum Excel Programming / VBA / Macros
Last Post: 06-22-2014, 08:44 AM
By ElTerrible in forum Excel General
Last Post: 07-31-2008, 09:34 AM
By skihula in forum Excel General
Last Post: 12-28-2005, 01:50 PM
By Screen/Display size in forum Excel General
Last Post: 08-19-2005, 10:05 AM
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1