ShowDetail

  • Thread starter Thread starter Les Gombart
  • Start date Start date
L

Les Gombart

When data is extracted using ShowDetail, the data is always extracted to a
new sheet. Is there any way that this data can be extracted to a named range?
 
How about letting it go to the new sheet, then copy|pasting to its correct home
(and delete that new sheet???).
 
Hi Dave...

I thought about that, but the problem is that a new sheet number is created
everytime you use the ShowDetail function... I have however re-thought my
reasoning and it is a lot easier to use advance filter macros to find the
same data from the original data

Thanks anyway
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA SQL Server Stored Procedure creating a Pivot Table 7
ShowDetail on PivotTable does not work in VBA 0
macro to show / hide grouping, linked to label button 3
Pivot table - How To Obtain a External data Source?? 2
VBA Pivot Table Error 1
Programmatically reading the excel sheet name-->vbscript 2
how to control outline group? show or collapse [vba] 1
Disable custom menu item based on visible cells 1

Back
Top