In Excel 2002 macro, go to cell in current row.
I want the macro to select the cell in column A but stay on the current row
which can be any row. Not all cells in every column have data so I cannot use the "End" feature. There are formulas in certain columns which need to be copied to newly inserted rows using the macro. It works as long as the cell in column A is selected before the macro is run. However, since other people will be using the spreadsheet, there is no guarantee they will select column A before running the macro. Any suggestions? Thank you. |
In Excel 2002 macro, go to cell in current row.
put the current cell location in a variable at the first of your macro, then
select cell in col a, then at the end of the macro, select the original cell whose location is recorded in the variable. "jannkatt" wrote: I want the macro to select the cell in column A but stay on the current row which can be any row. Not all cells in every column have data so I cannot use the "End" feature. There are formulas in certain columns which need to be copied to newly inserted rows using the macro. It works as long as the cell in column A is selected before the macro is run. However, since other people will be using the spreadsheet, there is no guarantee they will select column A before running the macro. Any suggestions? Thank you. |
All times are GMT +1. The time now is 02:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com