Macro help to move around spreadsheet

[Guest]

I am writing a macro to be used on different spreadsheets. I need the
keystrokes to program to go to the first empty cell in the leftmost column of
the spreadsheet. Do you know the keystrokes that will work in a macro? I
used the keystrokes on a spreadsheet that took me to A288, and then when I
applied it in another spreadsheet it took me to A288, not the actually empty
cell in the current spreadsheet. Can you help? Thanks, cm

 

[Jim Rech]

Many ways to do that, here's one:

Columns(1).SpecialCells(xlCellTypeBlanks).Cells(1).Select

--
Jim
|I am writing a macro to be used on different spreadsheets. I need the
| keystrokes to program to go to the first empty cell in the leftmost column
of
| the spreadsheet. Do you know the keystrokes that will work in a macro? I
| used the keystrokes on a spreadsheet that took me to A288, and then when I
| applied it in another spreadsheet it took me to A288, not the actually
empty
| cell in the current spreadsheet. Can you help? Thanks, cm

 

[Guest]

Thanks Jim - another ? - what if I need to move one up from that cell to cut
and paste the last cell's contents down. Then I need to move to the right,
one column at a time and add literals and formulas along the bottom. I
appreciate your help, cindy

 

[Jim Rech]

The Offset method is good for moving the active cell versus where it is:

ActiveCell.Offset(1).Select

move down one cell. -1 moves up. Check Offset in help for moving
right/left.

--
Jim
| Thanks Jim - another ? - what if I need to move one up from that cell to
cut
| and paste the last cell's contents down. Then I need to move to the
right,
| one column at a time and add literals and formulas along the bottom. I
| appreciate your help, cindy
|
| "Jim Rech" wrote:
|
| > Many ways to do that, here's one:
| >
| > Columns(1).SpecialCells(xlCellTypeBlanks).Cells(1).Select
| >
| > --
| > Jim
| > | > |I am writing a macro to be used on different spreadsheets. I need the
| > | keystrokes to program to go to the first empty cell in the leftmost
column
| > of
| > | the spreadsheet. Do you know the keystrokes that will work in a
macro? I
| > | used the keystrokes on a spreadsheet that took me to A288, and then
when I
| > | applied it in another spreadsheet it took me to A288, not the actually
| > empty
| > | cell in the current spreadsheet. Can you help? Thanks, cm
| >
| >
| >

 

[Guest]

Hi Jim, thanks that worked. Now I'm moving to the next column and I want to
count the number of items in the column. The number of rows will vary from
spreadsheet to spreadsheet. Thanks for your help, c