You can contact me by email at: jpgpinto (at) gmail (dot) com
Would like to hear from you. If you have some comments or sugestions about this blog, feel free to send me an email. I'll try to answer as soon as possible.
About Me
- jppinto
- Setúbal, Portugal
- Been using Excel for more than 10 years and still learning every day. Just started working with Excel 2010 and I'm lovin it!
Recent Articles
- MS Excel 2013 Quick Start Guide (“Cheat Sheet”)
- Install Excel 2013 side-by-side with Excel 2010
- "Your top 10 favorite Excel post of 2012" from Microsoft Excel Blog
- uCertify - Online Version
- Lookup with multiple criteria's
- AutoSum
- Conditional Formatting bar chart
- Add new data to an existing chart
- Add automatic subtotals
- Copy visible cells only
- Fill Blanks on column
- "VLOOKUP Great White Shark Award"
- Hide values on column for better looking when printing
- Format Painter: quickly copy formats
- Array Formulas
Recent VBA Articles
Popular Articles
Followers
Archive
- March 2013 (2)
- February 2013 (1)
- October 2012 (1)
- July 2012 (1)
- June 2012 (1)
- May 2012 (4)
- April 2012 (2)
- March 2012 (1)
- February 2012 (7)
- January 2012 (5)
- October 2011 (1)
- August 2011 (1)
- July 2011 (2)
- June 2011 (1)
- May 2011 (1)
- April 2011 (6)
- March 2011 (3)
- February 2011 (4)
- January 2011 (2)
- November 2010 (1)
- October 2010 (12)
- September 2010 (3)
- June 2010 (1)
- April 2010 (1)
- March 2010 (3)
- February 2010 (3)
- January 2010 (2)
- November 2009 (6)
- October 2009 (17)
6 comentários:
Excel 2010
Dealing with Worksheets
I am trying to find a way to calculate the total number of "worksheets" within a Excel file. I want the number to be placed into a cell on one of the worksheets. My Excel would be something with multiple worksheets, and 2-3 of them would not be someting I want as part of my count, so I believe if I can just find out the total I could than subtract 2 or 3 from it to get my total worksheets that I am interested in.
Do you know how I can do this? Via a function in a cell or by VBA?
Thank you for your time,
Doug from New York
Try this custom function. Use in any cell like
=SheetCount() for all Sheets
=SheetCount(True) for Worksheets only
VB:
Function SheetCount(Optional Worksheets_only As Boolean) As Long
If Worksheets_only = True Then
SheetCount = Worksheets.Count
Else
SheetCount = Sheets.Count
End If
End Function
Hello Mr. jppinto,
Thank you for you helpful blog.
I would ask if have an acount on twitter to teel us about your new post or send it by email.
Thank you,
Shroog
Hello,
Don't have a Twitter account.
Regards,
João Pinto
Hi Blogger ,
I Want to Know that there is any Formula is There for Adding Auto Number after two blank Rows .
For Best Understanding i have given a link of image ..
Image Preview :- http://s2.postimage.org/k509mbfhl/sshot_1.png
As you have noted the numbers are on the url cells after two blank cells ..like that i want the forumal to enter it auto..Thank You in Advance ..
This could be done only with VBA code.
Post a Comment