View Single Post
  #3   Report Post  
c_new
 
Posts: n/a
Default

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