Hi there. I'm trying to create a macro/shortcut key to go the first column
and either the current or next row that I'm in. I have the sheet froze as I
am working in a spreadsheet that has columns A - AZ and rows 1 - 1200. I
know I could use the TAB for the row and then ENTER but often I'm just using
my right hand (lots of data entry).

I've been cruising around this site and everyone is just so helpful! I've
found lots of answers and fun stuff to make my work more efficient. I
appreciate any and all assistance.

Thank You!
Cara

Sub SelectFirstCol()
cells(Activecell.Row,1).Select
End Sub

"c_new" wrote in message
...
Hi there. I'm trying to create a macro/shortcut key to go the first
column
and either the current or next row that I'm in. I have the sheet froze as
I
am working in a spreadsheet that has columns A - AZ and rows 1 - 1200. I
know I could use the TAB for the row and then ENTER but often I'm just
using
my right hand (lots of data entry).

I've been cruising around this site and everyone is just so helpful! I've
found lots of answers and fun stuff to make my work more efficient. I
appreciate any and all assistance.

Thank You!
Cara

Thank you! It took me a few minutes but it did what I needed. Thanks for
your expertise!

"Bob Umlas" wrote:

Sub SelectFirstCol()
cells(Activecell.Row,1).Select
End Sub

"c_new" wrote in message
...
Hi there. I'm trying to create a macro/shortcut key to go the first
column
and either the current or next row that I'm in. I have the sheet froze as
I
am working in a spreadsheet that has columns A - AZ and rows 1 - 1200. I
know I could use the TAB for the row and then ENTER but often I'm just
using
my right hand (lots of data entry).

I've been cruising around this site and everyone is just so helpful! I've
found lots of answers and fun stuff to make my work more efficient. I
appreciate any and all assistance.

Thank You!
Cara