- Joined
- Aug 29, 2009
- Messages
- 2
- Reaction score
- 0
Apologies if I have selected the incorrect forum ...
I need a way to set the initial active cell in a spreadsheet, then check that cell for a status, then, depending on the status reset the active cell.
I have played with auto_run and set initial cell using "Range("D3").Select
I now need to check the cell to see if it is filled. If it is filled I want to set range to another cell. If it is not filled I need to wait for user input.
So I'm thinking I need a loop that checks the status of D3 until it is filled then when it is filled resets active cell to D8.
Can anyone suggest a solution or point me to the appropriate research sites so I can come up with my own solution? I don't mind doing the research myself but there is just so much info out there and I have put several weeks of searching into this already that I would appreciate some good hints.
Thank you for your time and attention.
Ferg
I need a way to set the initial active cell in a spreadsheet, then check that cell for a status, then, depending on the status reset the active cell.
I have played with auto_run and set initial cell using "Range("D3").Select
I now need to check the cell to see if it is filled. If it is filled I want to set range to another cell. If it is not filled I need to wait for user input.
So I'm thinking I need a loop that checks the status of D3 until it is filled then when it is filled resets active cell to D8.
Can anyone suggest a solution or point me to the appropriate research sites so I can come up with my own solution? I don't mind doing the research myself but there is just so much info out there and I have put several weeks of searching into this already that I would appreciate some good hints.
Thank you for your time and attention.
Ferg