+ Reply to Thread
Results 1 to 5 of 5

Create New Sheet with specific rows and columns hidden

  1. #1
    Registered User
    Join Date
    02-09-2015
    Location
    Evanston, IL
    MS-Off Ver
    2010
    Posts
    6

    Create New Sheet with specific rows and columns hidden

    Good evening,

    I am reading through the VBA programming for dummies but doing the exercises on my 2011 Macbook Pro and have run into some issues. I tried to record a macro that would create a new sheet with that new sheet only displaying rows 1-10 and columns A-J (10x10) table. What I did is pasted below as well as what the book says I should've gotten, they do not match up. To make things more complicated, at least for me, then when i tried pasting the code from the book into VBA on my mac it wouldn't run it because there were multiple lines that were kicking back errors.

    Please Login or Register  to view this content.
    From the book:
    Please Login or Register  to view this content.
    Any help would be appreciated. I am much more interested in learning why things are working and why the code between the two are different than just getting a quick solution.

    Thanks

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,886

    Cool Hi, try this !


    Please Login or Register  to view this content.
    Do you like it ? So thanks to click on bottom left star icon Add Reputation !

  3. #3
    Registered User
    Join Date
    02-09-2015
    Location
    Evanston, IL
    MS-Off Ver
    2010
    Posts
    6

    Re: Hi, try this !

    Marc L,

    Thanks for your reply. Although your code does produce the desired result, as I stated in my question, I am just as interested in understanding why the code I wrote didn't work, not just finding a code that would. I am trying to learn how to write in code so I still don't have an answer to why mine was incorrect.

    Thank you for your time though.

  4. #4
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,886

    Re: Create New Sheet with specific rows and columns hidden


    I don't have any Mac so I just can tell your codes don't seem to have a connection with the subject problem !
    Maybe bad keystroke or mouse action using Macro recorder …

    _______________________________________________________________________________________
    Je suis Charlie

  5. #5
    Registered User
    Join Date
    02-09-2015
    Location
    Evanston, IL
    MS-Off Ver
    2010
    Posts
    6

    Re: Create New Sheet with specific rows and columns hidden

    Thanks I'll look into it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 08-14-2013, 03:32 PM
  2. Replies: 0
    Last Post: 04-11-2013, 05:33 PM
  3. [SOLVED] Convert specific rows into columns in Sheet 2 - VBA
    By missy22 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-23-2012, 09:31 AM
  4. Replies: 2
    Last Post: 07-20-2006, 02:51 PM
  5. Keeping Hidden Rows/Columns Hidden?
    By DMac in forum Excel General
    Replies: 0
    Last Post: 01-17-2005, 08:13 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1