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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by SiliconXu
-
excel 2003 summary page
If you want EXCEL not to show 0 value, you can do like this: Tool -> Option -> View(tab) -> Window options -> uncheck the "Zero value" Your last question: Without seeing your file, it's difficult to tell you how to do. You can use COUNTA to calculate the num of the non-blank column because a...- SiliconXu
- Post #7
- Forum: Microsoft: Office
-
Printing Sequential Numbers in Excel after Print
open the VBE and then type the code below in the "ThisWorkbook" object: Private Sub Workbook_BeforePrint(Cancel As Boolean) Static ab As Long ab = ab + 1 End Sub Here I use "Static" to declare the variable "ab" to make sure it retains its value as long as the code is running. Each time...- SiliconXu
- Post #2
- Forum: Microsoft: Office
