Jordan_WM
asked on
Excel 2003 Multipage Copy
Hello,
I have a multipage which has a list of transactions, what I want to do based on the types of transactions that are in the list box I want to create sub pages for each transaction type and copy the list box over to the name page and filter the list box data based on the transaction type.
I was trying to use something like this to copy everything over but it is not working.
With CorpBndProfile.MultiPage1
PagesCnt = .Count
Set newPage = .Pages.Add("Page" & (PagesCnt + 1), _
"Page " & (PagesCnt + 1), PagesCnt)
.Pages(PagesCnt).Controls. Copy
End With
newPage.Paste
I have a multipage which has a list of transactions, what I want to do based on the types of transactions that are in the list box I want to create sub pages for each transaction type and copy the list box over to the name page and filter the list box data based on the transaction type.
I was trying to use something like this to copy everything over but it is not working.
With CorpBndProfile.MultiPage1
PagesCnt = .Count
Set newPage = .Pages.Add("Page" & (PagesCnt + 1), _
"Page " & (PagesCnt + 1), PagesCnt)
.Pages(PagesCnt).Controls.
End With
newPage.Paste
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER