ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   cannot unhide rows/columns in the worksheet. (https://www.excelbanter.com/excel-programming/305705-cannot-unhide-rows-columns-worksheet.html)

No Name

cannot unhide rows/columns in the worksheet.
 
how can i unhide rows and columns. this doenst work:
Rows("1:2000").EntireRow.AutoFit
Columns("F:H").EntireColumn.AutoFit
Rows("1:2000").Hidden=False
Columns("F:H").Hidden=False

please suggest something

thanks in advance


No Name

cannot unhide rows/columns in the worksheet.
 
sorry for the repeated display of the query. i accidently
pressed 3-4 times the send button when i didnt get hte
message that "the query has been posted"

apologies!
-----Original Message-----
how can i unhide rows and columns. this doenst work:
Rows("1:2000").EntireRow.AutoFit
Columns("F:H").EntireColumn.AutoFit
Rows("1:2000").Hidden=False
Columns("F:H").Hidden=False

please suggest something

thanks in advance

.



All times are GMT +1. The time now is 06:37 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com