[Solved] Changing active cell range in spreadsheet

  • My spreadsheet only has data in about 50 rows and 10 columns but for some reason the cursor on the right is SO small and is acting like we are using the entire spreadsheet down to row 30K! I remember there was a function that you could highlight the cells you are using and then press control save but that is not working - any suggesions?

  • Not sure but try this macro:



    HTH

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

  • I'm no guru - the macro was filched from the microsoft knowledge base!


    If you mean how do you run the macro then whilst in xl hit Alt+F11. On the left hand side you should see the project explorer window (if not hit Ctrl+R). You should see your workbook listed as VBAProject (yourworkbook name) - right-click on it and choose insert module. Paste the code into this. If you flip back to xl the macros can be run from Tools>Macro>Macros


    That what you mean?

    <a href="http://www.mrexcel.com/relayforlife.shtml" target="new"><img src="http://www.myimgs.com/data/vonpookie/anne_relay.gif"></a>

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!