|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 2nd, 2004, 07:26 AM
|
|||
|
|||
unhide rows adn columns
how can i unhide rows and columns. this doenst work:
Rows("1:2000").EntireRow.AutoFit Columns("F:H").EntireColumn.AutoFit thanks in advance 
|
|
#2
August 2nd, 2004, 07:59 AM
|
|||
|
|||
|
unhide rows adn columns
Try
Rows("1:2000").Hidden=False Columns("F:H").Hidden=False -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS wrote in message ... how can i unhide rows and columns. this doenst work: Rows("1:2000").EntireRow.AutoFit Columns("F:H").EntireColumn.AutoFit thanks in advance
|
|
#3
August 2nd, 2004, 08:09 AM
|
|||
|
|||
|
unhide rows adn columns
hi nick thanks for the reposne.
i tried this and somehow nothing happens...! any other suggestion? thanks -----Original Message----- Try Rows("1:2000").Hidden=False Columns("F:H").Hidden=False -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England wrote in message ... how can i unhide rows and columns. this doenst work: Rows("1:2000").EntireRow.AutoFit Columns("F:H").EntireColumn.AutoFit thanks in advance .
|
|
#4
August 2nd, 2004, 07:58 PM
|
|||
|
|||
|
unhide rows adn columns
Did you write the code or is this commercial? That is the syntax for
unhiding rows and columns. All I can think is that the worksheet is protected and the error (1004) is being trapped and handled or there is some event code that is re-hiding them Anyone else? -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS wrote in message ... hi nick thanks for the reposne. i tried this and somehow nothing happens...! any other suggestion? thanks -----Original Message----- Try Rows("1:2000").Hidden=False Columns("F:H").Hidden=False -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England wrote in message ... how can i unhide rows and columns. this doenst work: Rows("1:2000").EntireRow.AutoFit Columns("F:H").EntireColumn.AutoFit thanks in advance .
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Drop Down Filter, Unhide Rows | Rich9016 | General Discussion | 5 | July 15th, 2004 11:41 PM |
| columns to rows and rows to columns | time | General Discussion | 1 | June 23rd, 2004 02:44 PM |
| Conditional Hiding of Rows or Columns | sanjay_suda | General Discussion | 6 | June 18th, 2004 04:03 PM |
| Using + / - to hide unhide rows or columns | Don Jungst | Worksheet Functions | 2 | June 14th, 2004 07:48 PM |
| Displayed Rows and Columns Excel 2000 | Roy | Worksheet Functions | 2 | April 14th, 2004 05:11 PM |
Linear Mode
