PDA

View Full Version : macro deleting important data in column F:EC



Pete
08-05-2008, 08:14 AM
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....

Pete
08-05-2008, 08:15 AM
work book

mdmackillop
08-06-2008, 12:19 AM
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.