Paste the data using the transpose command. Press the Replace All button. Press the OK button in the pop up that follows, again it should say we made 6 replacements as there were 6 formula’s in our range.In the Find what box type in #= and in the Replace with box type in =.Select the cell where you want the transposed data. Now we have a transposed version of the original range and all the formula’s have maintained their original references.If you wish to always have the macro available and not just when one particular workbook is open - i.e. the macro is a "generic" macro it is better to place the macro in your Personal Macro Workbook. This is a workbook that Excel automatically creates. If you use the Macro Recorder to record a macro, the dialog box asks where you want to store the macro: (a) the active wb, (b) a new wb or (c) in your Personal Macro wb. If you select Personal Macro Workbook and you have not previously recorded a macro there, Excel will create it for you, naming it Personal.xls and placing it in your Excel startup directory. This way every time you start Excel, Personal.xls will load and its macros will be available to you. Normally that's going to be:Ĭ:\Documents and Settings\username\Application Data\Microsoft\Excel\XLSTART\ (Note that Personal.xls is a hidden workbook and not an Excel Add-In.)Įxcel will put it in your startup directory.
0 Comments
Leave a Reply. |