Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
using variable to select rows in Excel
Skip, What are the principal differences between zero height and hidden rows? For my purposes, I merely wanted to avoid printing rows which do not contain data. The macro I am using simply "hides" (by zero height) the rows during the printing operation and then resets the height for...- RodneyFAA
- Post #10
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variable to select rows in Excel
BarneyOwl -- There was not reason for not using the hidden function. Zero row height and hidden create the same result. I just needed the syntax to make it happen. Thanks Skipvought -- Thanks for the tip on the AutoFilter. I assume it would also provide the same result. Unfortunately, I am...- RodneyFAA
- Post #8
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variable to select rows in Excel
Thank You. This works great.- RodneyFAA
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variable to select rows in Excel
My apologie.. The code that works is Rows("13:150").Select Selection.RowHeight = 0- RodneyFAA
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
using variable to select rows in Excel
I would like to hide (rowheight = 0) empty rows when preparing to print a spreadsheet. The following code works but I would like to replace the values (13 and 150) with variables I can identify elsewhere. Can a variable be used with "rows" or do I need to use something else? If a variable is...- RodneyFAA
- Thread
- Replies: 10
- Forum: VBA Visual Basic for Applications (Microsoft)
