VBA - With Range Selected, how to back up one row?

[clemsoncooz]

Please excuse me for I am very new at this. I dont know the code lanuage on how to do it.

My goal is to automate with a macro, these stroke combinations. (the macro recorder is not working the way I need it to).

If I was using keyboard short cuts =
1) Select H117 on Sheet7
2) ctrl + shirt + down arrow
3) shift + up arrow

I currently have (and I know its WRONG)...

Please Login or Register  to view this content.

Any help is greatly appreciated. Thanks in advance.

[Firefly2012]

So you want to select everything bar the last row of data?

Please Login or Register  to view this content.

Note that you rarely ever need to Select anything to work with it - it makes your code slower and less efficient than it could be. But for learning I think it's fine.

[clemsoncooz]

yup! wonderful! Thank you!