Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I would like to know how to move the:
First record (disregarding filter settings ]) would this be some thing like activecell(-row(),0) First VISIBLE record Last record (disregarding filter settings) Last VISIBLE record I want these setting for my nav bar. Would I hen ge something like set rMarker to firstrow() ' or what ever command that you tell me...) activecell(rMarker,0) The next/prev I have hammered out and it works fine How do I use the SCROLL bar to move to a given record, and how do I update the scrollbar? I have the SCROLLBAR working for the next/prev. If it filter is in place amd I do NOT what to see hidde, then I update the varible plus or minus 1 for each time I press the up/down (and test for <1 and greater than record count) and if filter, then ONLY when the keys are pressed AND record is not hidden. I need to find out what the current record postion I am on currently How do I get the record or record when aq FILTER is set? I know there is a command that will give me the count of visible rows, how do I do this? Thanks I know these are basic questions, but I have not been able to find the answers in any of my books, or the web (I KNOW it is there...) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Things to do with the cells | Excel Discussion (Misc queries) | |||
A few things | Excel Worksheet Functions | |||
Top 10 Things To Look For In A Web Host | Excel Worksheet Functions | |||
how to do these things in Excel with and without VBA? | Excel Discussion (Misc queries) | |||
######THEY DO DIFFERENT THINGS TO GET IT############# | Charts and Charting in Excel |