Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to first blank sheet
Hello,
I have an application with many hidden sheets. A macro will unhide sheets based on a criteria. The user then responds to questions and a score is calculated. No problem so far. However, if the user backs out of these sheets and re-enters via the macro, I need for them to be taken to the sheets that haven't yet been entered/altered. I need this to work in Excel 95 and up and I understand there are compatibility problems with OnEntry, OnData in 95 and On Wookbook_Change in 97 etc. Any thoughts? Thanks very much in advance. Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Move to first blank sheet
Something like this should work in all versions.
Sub gotoblanksheet() For Each sh In Worksheets If Len(sh.Range("a1")) < 1 Then sh.Select Exit Sub End If Next End Sub -- Don Guillett SalesAid Software wrote in message ups.com... Hello, I have an application with many hidden sheets. A macro will unhide sheets based on a criteria. The user then responds to questions and a score is calculated. No problem so far. However, if the user backs out of these sheets and re-enters via the macro, I need for them to be taken to the sheets that haven't yet been entered/altered. I need this to work in Excel 95 and up and I understand there are compatibility problems with OnEntry, OnData in 95 and On Wookbook_Change in 97 etc. Any thoughts? Thanks very much in advance. Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
move blank data | Excel Discussion (Misc queries) | |||
Move data to new sheet - rename sheet based on criteria ? | Excel Discussion (Misc queries) | |||
move rows of data seperated in a sheet to a sheet with no separat | Excel Worksheet Functions | |||
Move to next blank cell in column | Excel Programming | |||
Move non date/add blank row | Excel Programming |