Wookiee213
New Member
- Joined
- Oct 16, 2014
- Messages
- 34
Hi All
Very minor issue but curious to know if there's a way round it.
I have some code which generates a report and emails it to the recipients, part of this code is applying grouping on certain data within the report.
I've noticed that when the user expands the group (based on Rows rather than Columns) the screen jumps to the last row in the group rather than remain at the first row in the group after expanding.
Is there anyway of getting round this when setting up the grouping?
While I can think of numerous ways to get round it using VBA I am reluctant to send a report (workbook) which requires the recipient to enable macros.
Thanks
Very minor issue but curious to know if there's a way round it.
I have some code which generates a report and emails it to the recipients, part of this code is applying grouping on certain data within the report.
I've noticed that when the user expands the group (based on Rows rather than Columns) the screen jumps to the last row in the group rather than remain at the first row in the group after expanding.
Is there anyway of getting round this when setting up the grouping?
While I can think of numerous ways to get round it using VBA I am reluctant to send a report (workbook) which requires the recipient to enable macros.
Thanks
