navigating the spreadsheet

[JBCA]

Hello,

I'm trying to learn vba to replicate a number of complex spreadsheets written in a competitor's format (time to get with the rest of the world and use excel). Where do I find the commands to move around in the sheet. If I know the commands I believe I can do it but so far can't find them.

For a simple example, I want to have a macro that works anywhere to total the occupied cells above the current cell when the number of occupied cells is unknown. In my old macro it read,

{Up} [moves to the cell above current]
{Shift+End} [equivalent of pressing the shift and end keys together]
{Shift+Up} [selects all of the occupied cells}
{Speedsum!} [totals]

Any help would be appreciated.

Jim

[Bryan Hessey]

Hello,

I'm trying to learn vba to replicate a number of complex spreadsheets written in a competitor's format (time to get with the rest of the world and use excel). Where do I find the commands to move around in the sheet. If I know the commands I believe I can do it but so far can't find them.

For a simple example, I want to have a macro that works anywhere to total the occupied cells above the current cell when the number of occupied cells is unknown. In my old macro it read,

{Up} [moves to the cell above current]
{Shift+End} [equivalent of pressing the shift and end keys together]
{Shift+Up} [selects all of the occupied cells}
{Speedsum!} [totals]

Any help would be appreciated.

Jim

Hi,

variations of

Please Login or Register  to view this content.

might help you.

---