get only range with multiple evdre
how to get to select only one EVDRE cells to send data when i have two evdre's ina worksheet.
Well i tried with having applied getonly range to complete one EVDRE, but when i tried to send I still see that the dimensions and members from the first evdre are read.
inthe first evdre i have parent members and so the EVDRE is not successfull when sending data from the second evdre
Poonam Shukla replied
Whenever you are sending data, it has to be send on the base level members only. If you enter it in the parent level members, it will not be sent.
If you dont want to send data for a particular membersheet you can enter NOSEND in Option range. It will not send any data for that EVDRE report.
While sending the data for some EVDRE, you are always asked for Active Worksheet to Workbook option. If you select worksheet, it will only send data for that particular worksheet only.
Hope this clarifies.