Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help to move around spreadsheet
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help to move around spreadsheet
Many ways to do that, here's one:
Columns(1).SpecialCells(xlCellTypeBlanks).Cells(1) .Select -- Jim "cindy" wrote in message ... |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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help to move around spreadsheet
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 "cindy" wrote in message ... |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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help to move around spreadsheet
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 "cindy" wrote in message ... | 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 | "cindy" wrote in message | ... | |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 | | | |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro help to move around spreadsheet
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 "Jim Rech" wrote: 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 "cindy" wrote in message ... | 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 | "cindy" wrote in message | ... | |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 | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I move a page of my spreadsheet? | Excel Discussion (Misc queries) | |||
excel-how to get the spreadsheet to move as I move the scroll tab | Excel Discussion (Misc queries) | |||
cannot move a column in my spreadsheet | Excel Discussion (Misc queries) | |||
Tab and Enter key to move in spreadsheet? | Setting up and Configuration of Excel | |||
how do I move a spreadsheet into word | Excel Worksheet Functions |