-
macro deleting important data in column F:EC
Hi
See attached workbook......
Not sure why the macro is deleting the source data in columns F:EC for tables with the heading demand only three tables in total....
row 27, 68 and 109 worksheet "Volume Summary"....
when the user click the macro button in the worksheet "Volume Summary" is adjust to accordlingly to the data in worksheet "Deal Selection" columns B and I......
however the macro is also deleting the data in tables for demand customers only starting in row 27, 68 and 109
how do i amend to stop this happening....
-
-
Hi Pete,
You need to step through your code and watch what is happening. You may need to add some Activate and Select code to move to affected ranges. That should let you pin down the code section involved.
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules