How to add number of sheets in workbook
Closed
ravi
-
Mar 22, 2010 at 08:44 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 23, 2010 at 08:01 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 23, 2010 at 08:01 AM
Related:
- How to add number of sheets in workbook
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
- How to add songs to sound picker - Guide
- How to add photo in word resume - Guide
- How to add watermark in word - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 23, 2010 at 08:01 AM
Mar 23, 2010 at 08:01 AM
dim sheetChange as integer
sheetchange = cells(2, "A")
if (sheetchange>0) then
for i=1 to sheetchange
sheets.add
next
end if
For sheet delete, there is an issue. What sheets is to be deleted. Can any sheet be delete including the one from where vale in cells A2 was read ?
for i=1 to sheetchange
sheets(i).delete
next
sheetchange = cells(2, "A")
if (sheetchange>0) then
for i=1 to sheetchange
sheets.add
next
end if
For sheet delete, there is an issue. What sheets is to be deleted. Can any sheet be delete including the one from where vale in cells A2 was read ?
for i=1 to sheetchange
sheets(i).delete
next
