I have a speadsheet with some macros and I have a couple questions.
Basically the macros with take a very wide speadsheet and after some manipulation will have it stacked in Column 1 and 2. This works fine. The pesty issue is when the macro is finished my cursor if way out to the right where there is no data anymore. I would like the last piece of code in the macro to move the spreadsheet to its normal position with cell A1 top left. I poked around and played with some code but I think I am making this too complicated.
The last thing is a Best Practice question.
What is the Best way to store macros to be used in any open speadsheet instead of having me only paste my data to one existing sheet. I would like to have it always available. I guess perhaps some type of add in or something. But I think for me to make an add on I need to convert the macros to code, correct? and then do something to make it an add in. If there is a better (Best Practice) way I would love to hear it.
I appreciate any assistance.
Basically the macros with take a very wide speadsheet and after some manipulation will have it stacked in Column 1 and 2. This works fine. The pesty issue is when the macro is finished my cursor if way out to the right where there is no data anymore. I would like the last piece of code in the macro to move the spreadsheet to its normal position with cell A1 top left. I poked around and played with some code but I think I am making this too complicated.
The last thing is a Best Practice question.
What is the Best way to store macros to be used in any open speadsheet instead of having me only paste my data to one existing sheet. I would like to have it always available. I guess perhaps some type of add in or something. But I think for me to make an add on I need to convert the macros to code, correct? and then do something to make it an add in. If there is a better (Best Practice) way I would love to hear it.
I appreciate any assistance.
