Select Case penmExcelVersion Case enmExcel2003 intLastRowOfSheet = 65536 Case enmExcel2007 intLastRowOfSheet = 1048576 End Select
|What code would I use to automate changing the tab (sheet) names in an excel spreadsheet?||17||41|
|adding to,subject,body for the opened mail instead of creating new mail||15||32|
|Conditional Format - Prevent User entering USA Date formats into Excel 2010||3||22|
|excel cannot open the file because the file format or file extension is not valid||5||30|
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
18 Experts available now in Live!