How to add number of sheets in workbook
Closed
ravi
-
Mar 22, 2010 at 08:44 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 23, 2010 at 08:01 AM
rizvisa1 Posts 4479 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
- How to add accent over e - Guide
- Pdf and xps add in 2007 - Download - Other
- How to add @ in laptop - Guide
- How to add featured channels on youtube - Guide
- Why can't i add a contact to whatsapp - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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