Hello everyone,
I have this workbook I have been working on and I just need help with a macro to get sheets after a certain sheet exported into values. I have attached the worksheet below and my attempt at trying to do this macro. The sheets I need to export are all the sheets after the template sheet.
Attached is the link to the worksheet https://www.dropbox.com/s/eujzhosl2p...orum.xlsm?dl=0
Please Login or Register to view this content.
Thanks in advance for your help
Last edited by JBeaucaire; 02-13-2017 at 10:55 PM. Reason: Added missing CODE tags. Please read and follow the Forum Rules, link above in the menu bar. Thanks.
I have found a way to select all the worksheets including the template by using this macro. How would I unselect the template sheet and move those selected sheets to a newworkbook as values?
'Select Sheet Macro
Sub sheetsforexport()
Dim ws As Worksheet, flg As Boolean
For Each ws In ThisWorkbook.Sheets
If ws.Range("a1").Value = 1 Then
If flg Then
ws.Select False
Else
ws.Select
flg = True 'This section selects all the sheets that were produced as well as the template
End If
End If
Next
End Sub
How about
Please Login or Register to view this content.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Perhaps.
Please Login or Register to view this content.
If posting code please use code tags, see here.
Thank you guys, these worked perfectly!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks